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
Смотрите видео Raw SQL queries & stored procedures in Entity Framework Core онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Round The Code 25 Февраль 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,240 раз и оно понравилось 90 людям.