How to use a SQL query result as an object in Entity Framework?
<p>I'm creating a data analysis process in c# using EF (code first). The data model involves about a dozen interrelated classes.  Most of these directly correspond with tables in an existing database, but a couple key read-only object types are really the product of complex, multi-step SQL queries.  I can't create a view or stored proc for the query.  </p>

<p>I'd like to be able to use something like DbSet.SqlQuery() to load those query results into EF objects, and still leverage EF's ORM features to relate them with the rest of the object graph.  </p>

<p>I think what I want is a way to override EF's SQL SELECT code when the DbSet tries to populate that query-based object from the database. Is this possible?  Is there a better alternative approach?</p>