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

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

[alanyoungjr]

Thank you again! Your tutorials are phenomenal. I only learn concepts well when I understand the practical uses and the logic behind the concept. You are clearly a master educator and I can’t thank you enough.

[adityarane]

Genuinely you have overpowered me with your communication skills and the way you explain each and every point.

[belongstomyself]

thanks tim, you saved me a ton of time looking up all the cool tips from every where .. I find it really easy following your tips and you actually make it look so simple, yet you still show a glimpse of its full potential enough to help everyone watching your videos to pick the best scenario for his needs ! I appreciate your hard work !

[mrf]

Very informative and worth while. very productive 44min. Watching in 2021 questioning myself why didn't watched it before, could had saved me from lots of grief in some of my projects. Keep up the good work. Thank you!

[RalfsBalodis]

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

[ob.]

Man thank you all this information you gave at each answer. You're taking care of your channel as your house. This is what is called effort! I hope you get millions of subscribers in short time.

[nickpollard]

Thanks Tim, your videos have really helped me professionally :)

[ob.]

"A junior developer writes simple code to do simple things. A mid-level developer writes complex code to do complex things. A senior developer writes simple code to do complex things." by Tim Corey

[DaniLearnsIT]

I am so glad you mentioned that advanced dapper covers nested objects in your other video. This is exactly what I needed! :)

[summerbreezesyria]

As a software engineer, when I was a student I didn't get many topics in database, and I thought that it is impossible to learn how to do it. Thanks to you I am more confident in doing database connections now. I really appreciate it. Thank you.

[richardshi]

As always, Tim Corey gave a top level instruction on using Dapper.

[bardus_hobus]

Just want to mention you've been so much help as I go through college for this. Right now, I simply don't have enough money to help in return, but once I land my first job, I want to contribute back!

[muhammadwaqasaziz]

You are a teacher of teachers!!!! MAN YOU KNOW HOW TO TEACH!!

[jopsuey]

The evolution of Microsoft Applications Blocks.. Excellent video Tim, greetings from Chile

[mdrahbarahmedkhan]

I have just 2 years of experience working on WPF technology, I have learned so much from you. Thank you very much from my heart ♥. ☺

Still waiting for WCF tutorial

[winchin]

thank you for all the great contents. I don't comment often, but I have watched many of your videos and liked all of the videos that I have watched.

[shelleycurrie]

Thank You Tim Corey for your really amazing tutorials, you explain the technical aspects really well and have helped me out of challenging coding situations a number of times now.

[torrvic]

Amazing examples as usual, Mr. Corey! I really need to wrap my head around this DataSets to understand how to insert the whole prepared table onto another empty table. But this is fine.

[girornsveinsson]

I would love to see a video from you covering Dapper implementations of repository-, unitofwork- and specification patterns with possible eager loading of navigation properties. Everything I find on this revolves around Entity Framework, but I think you have made good arguments against EF and I prefer avoiding using it for anything else than authentication and user management. I am really hoping that Dapper can be a good alternative. Maybe some extensions that have been made to Dapper and available as nuget packages can make it even a better choice.

[JohnMarsing]

Great video Tim, I've been using dapper for a couple of years and appreciated this video.