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:
• 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
Watch video Raw SQL queries & stored procedures in Entity Framework Core online without registration, duration hours minute second in high quality. This video was added by user Round The Code 25 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,240 once and liked it 90 people.