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
On this page of the site you can watch the video online Raw SQL queries & stored procedures in Entity Framework Core with a duration of hours minute second in good quality, which was uploaded by the user Round The Code 25 February 2024, share the link with friends and acquaintances, this video has already been watched 6,831 times on youtube and it was liked by 108 viewers. Enjoy your viewing!
