Advanced Dapper in C# – SQL Transactions, Mulitple DataSets, UDTs, and more



Source Code: https://leadmagnets.app/?Resource=AdvancedDapper
Full courses: https://www.iamtimcorey.com/
Blog Post: https://www.iamtimcorey.com/blog/20565/advanced-dapper
Patreon: https://patreon.com/IAmTimCorey
Newsletter signup: https://signup.iamtimcorey.com/

If you have watched any of my videos that include data access, you are probably familiar with Dapper. Dapper is a micro-ORM built by the team behind Stack Overflow for the purpose of getting data in and out of databases. It is quick, easy to use, and easy to debug. In this video, I am going to cover some of the advanced scenarios that you can use Dapper with including User Defined Table Types, Transactions, multiple data sets and more.

Timestamps contributed by: Ralfs HBK
0:00 – Intro
1:34 – Demo app: Database overview
5:20 – Demo app: Class Library overview
7:17 – Multiple object mapping
15:56 – Multiple object mapping with parameters
19:00 – Multiple Data sets
21:44 – Multiple Data sets with parameters
23:43 – Parameter output form database
28:43 – Safe Transactions
37:25 – Insert Data Set
42:37 – Concluding remarks

Comments are closed.