title: How to get values returned by stored precedure in MySql + EntityFramewrok
body: <p>We are using EntityFramework and CodeFirst with MySql Database. In DB I created a stored procedure:</p>
  
  <pre><code>CREATE PROCEDURE `GetDepartmentPath`(leftKey INT, rightKey INT)
  BEGIN
  .....
  END
  </code></pre>
  
  <p>I tried executing code from <a href="https://stackoverflow.com/questions/4845246/does-entity-framework-code-first-support-stored-procedures">here</a> and <a href="https://stackoverflow.com/questions/5544061/stored-procedures-and-ef-code-first">here</a>(what is very similar to first link), but I always get a NotSupportedExeption. Is there a simple way to execute stored procedures using codefirst and get just a collection of entities?</p>