Using Stored Procedures in ASP.NET Core

---

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.

[minejohn]

Thank you!! clear explanation and straight to the point without wasting time.

[BenHayat]

I'd use Dapper as it offers a much cleaner implementation than legacy ADO.

[brunopromano]

Why the methods in ValuesRepository class return a Task? What Task means?