Raw SQL queries & stored procedures in Entity Framework Core

Опубликовано: 23 Март 2025
на канале: Round The Code

5,240

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:
• Get started with EF Core - Full course

💻 Download the code example💻
https://www.roundthecode.com/dotnet-c...

📖 Learn .NET and C# with our online courses 📖
https://www.roundthecode.com/dotnet-c...

👨‍💻Take our .NET and C# coding challenges👨‍💻
https://www.roundthecode.com/dotnet-c...

► 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