Raw SQL queries & stored procedures in Entity Framework Core

Publicado em: 25 Fevereiro 2024
no canal de: Round The Code
6,831
108

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


Nesta página do site você pode assistir ao vídeo on-line Raw SQL queries & stored procedures in Entity Framework Core duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Round The Code 25 Fevereiro 2024, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 6,831 vezes e gostou 108 espectadores. Boa visualização!