Use DAPPER To Create a .Net 7 CRUD Api & Call Stored Procedures

preview_player
Показать описание
How To Use DAPPER To Create a .Net 7 CRUD Api & Call Stored Procedures
Dapper is an ORM that can be used a alternative to Entity Framework depending on your circumstances. In this video I go over how to create a Crud .Net 7 api with Dapper. Also, I show everyone how to call a Stored Procedure using Dapper. The links to all the code you see are in the Github link below.

#Dapper #storedprocedure #dotnetapi

TimeStamps
----------------------------
00:00 Intro
00:45 What Is Dapper? How is it better than EF?
02:32 Our .Net 7 API Project and SQL Database
03:52 Nuget Packages For Dapper To Work
04:27 Creating Our Controller & Project Folders
06:04 Creating Our Dapper Controller Endpoints
08:00 Creating Our Interface
08:56 How To Use Dapper For .Net CRUD Endpoints
19:44 How To Call A Stored Procedure Using Dapper In .Net 7 API
22:04 How To Commit & Rollback Transaction When Using Dapper
23:24 Demo Of Our CRUD .Net 7 API with Dapper
Рекомендации по теме
Комментарии
Автор

Will you guys be using Dapper over Entity Framework in your next .Net API? Let me know why you are or why not! :)

IsraelQuiroz
Автор

Dude thank you! I've been waiting for a video like this!

LuisHernandez-lify
Автор

I use ADO about 90% of the time, but now I am moving to dapper, I prefer using stored procedures always, let sql do sql stuff, for me, it is better that way, thanks for a great vid, new sub bro!

guillermomazzari
Автор

Thanks, one question how do you scaffold your models?

anthonybaraujogarcia
Автор

Nice Tutorial. You just got a new subscriber! why Singleton Lifetime for DapperContext over Scoped Lifetime. Any performance benefit ?

viktorrimoru