Using Stored Procedures in ASP.NET Core

Blog: https://gavilan.blog
Github repo: https://github.com/gavilanch/ASPNETCORE_StoredProcs
Gist with SQL Script: https://gist.github.com/gavilanch/59a011c18fa59a98ef71d9fc775b7730

—

Although we like Entity Framework Core, there are occasions when the appropriate tool to work with the logic of data access in our application is ADO.NET. Given this, it is important that we know how to handle the stored procedures.

Stored procedures allow us to encapsulate operations that we will perform in a database. Whether they are writings, deletions, complex operations that involve several tables, and even simple readings; stored procedures allow us to place this logic in an easily accessible place for our applications.

In this video we will see how to work with stored procedures in the context of ASP.NET Core. The stored procedures will be created in SQL Server.