title: Entity Framework core stored procedure
body: <p>I am working with EF Core (code-first), and want to grab the data from a stored procedure. The returned result should be the class I defined based on the result return. </p>
  
  <p>I could make it work if the return type is one of the entities. ex. </p>
  
  <pre><code>_context.Set&lt;Entity&gt;().FromSql("dbo.Stored_Proc").ToList(); 
  </code></pre>
  
  <p>but not if my return values are not an entity in the context.</p>
  
  <p>Any help would be appreciated.</p>