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