EF8 - Row SQL returning Non-entities
Briefly

In EF8 now it is possible to include any row SQL query that is returning any mappable C#/.NET type, without the need to include that type in the EF model.
Such queries can be executed using [3] or [4]. The result is of type System.Linq.IQueryable<TResult> and in most cases can be subject to further LINQ manipulation.
Since EF8 it is possible to write row SQL queries that are returning any mappable non-entity type.
Please note that in example 1.5 we are relying on the fact that SqlQuery method returns IQueryable, which can be subject to further LINQ expressions.
Read at CodeProject
[
|
]