Blog - SQL Server

Swimburger
Screenshot of Visual Studio with EF Raw SQL Code

Querying data using raw SQL & Stored Procedures in Entity Framework Core

- .NET
When LINQ queries can't meet the performance requirements of your application, you can leverage Raw SQL and still have EF map the data to concrete .NET objects. You can also invoke Stored Procedures in case the logic of the SQL queries need to reside in the SQL Database.