Raw SQL queries & stored procedures in Entity Framework Core

This tutorial will use an EF Core query to run a raw SQL query and execute a stored procedure from a SQL Server database.

We'll have a look at the FromSql and FromSqlRaw methods in Entity Framework Core and how they can be used to write SQL.

We'll also show you how to add a stored procedure to a context and how to add a parameter to a SQL query.

Finally, we'll execute our queries using ASP.NET Core Web API endpoints to output the results.

► This is part 6 of our Get started with EF Core course. View the full playlist:

💻 Download the code example💻

📖 Learn .NET and C# with our online courses 📖

👨‍💻Take our .NET and C# coding challenges👨‍💻

► Chapters
0:00 What we'll cover
0:11 Nuget packages
0:59 SQL queries
4:19 Stored procedures
7:46 Learn more about EF Core

#efcore #entityframework #entityframeworkcore

[cissemy]

Great.
How to create the pagination version of stored procedure ?

[Tamer_Ali]

Thanks a lot for the useful video
Can we use DTO class instead of existing entity with FromSqlRaw ?