Native SQL Queries in Entity Framework

January 12, 2011
ADO.NET Entity Framework (EF) is powerful object-relational persistence framework. It has great capabilities for querying the database with LINQ but sometimes a custom native SQL could be more efficient way to execute a certain native SQL command or query directly at database level. To execute native SQL query in EF you could use the following