EF Core + Stored Procedures: The Right Way to Call Legacy SQL скачать в хорошем качестве

EF Core + Stored Procedures: The Right Way to Call Legacy SQL

Get the source code for this video for FREE → https://the-dotnet-weekly.kit.com/efs... Want to master Clean Architecture? Go here: https://bit.ly/3PupkOJ Want to unlock Modular Monoliths? Go here: https://bit.ly/3SXlzSt In this video, I break down how to work with stored procedures and SQL functions in EF Core, using practical, real-world examples. You’ll learn: • How to call stored procedures using ExecuteSqlAsync • How to execute SQL functions and capture return values • How to safely pass parameters and avoid SQL injection with FormattableString • How to project raw SQL results into DTOs • How to use FromSql for table-returning functions • How these patterns fit into Minimal APIs and modern .NET applications • When stored procedures actually make sense in a clean architecture—and when they don’t If you maintain a legacy system, work with Postgres-specific features, or need a safe escape hatch from LINQ, this video walks you through the most reliable patterns for combining SQL and EF Core. I hope it helps you integrate stored procedures cleanly into your .NET projects. Using Stored Procedures and Functions With EF Core and PostgreSQL https://www.milanjovanovic.tech/blog/... Check out my courses: https://www.milanjovanovic.tech/courses Read my Blog here: https://www.milanjovanovic.tech/blog Join my weekly .NET newsletter: https://www.milanjovanovic.tech Chapters