Entity Framework 8 brings a new feature allowing us to execute and return unmapped types from SQL select statements. In this blog post we'll take a quick look at how we can accomplish this, and why this is an important tool to have in your toolkit.

Tim Deschryver

Entity Framework Core 8 Preview 1 introduces the ability to execute raw SQL select statements and map results to any unmapped type, not just natively supported primitives or database model entities. Using the new SqlQuery and SqlQueryRaw methods, developers can now write custom SQL queries returning arbitrary types. This is useful for data migration tasks, hot code paths requiring fine-grained query optimization, and reducing dependencies on additional ORMs like Dapper. The feature returns IQueryable, and SqlQuery is preferred over SqlQueryRaw to avoid SQL injection risks.

You can now return unmapped types from raw SQL select statements with Entity Framework 8