Our Summer Sale is Live! 🎉
Everything 30% off with code SUMMER30! (Excl. Team and VS Pro)
00
Days
00
Hrs
00
Min
00
Sec
Get 30% off anything!

From Zero to Hero: Dapper in .NET

Learn how to use Dapper, the most popular .NET ORM

Dapper is by far the most popular ORM in .NET, and for good reason. It offers an excellent developer experience and performance without sacrificing the control that developers need over their database operations. It is the best of both worlds between handwriting ADO.NET queries by hand and using Entity Framework Core, which leaves all control to whatever the library decides to do behind the scenes. In this course, Microsoft MVP and CTO Nick Proud will assume you know nothing about Dapper and, by the end of the course, will have taught you everything you need to know to use Dapper effectively in production.

Curriculum

Welcome (01:13)

What will you learn in this course? (02:07)

Who is the course for and prerequisites (01:24)

What is Dapper? (01:28)

What is an ORM? (02:14)

What is a Micro-ORM? (02:07)

Why use Dapper? (10:17)

Installing Dapper (01:45)

Dapper vs Entity Framework (06:16)

Querying Single Columns with Execute Scalar (11:13)

Querying Single Rows (05:34)

Querying Multiple Rows and Values (05:11)

Retrieving Data Asynchronously (03:36)

Inserting Data (11:45)

Deleting Records (04:42)

Updating Records (03:31)

Why Use the Reader? (03:12)

The ExecuteReader Method (06:50)

One-To-Many Relationships in Dapper (11:08)

Many-To-Many Relationships in Dapper (06:44)

What is CRUD? (04:21)

The Repository Pattern (04:29)

Building Models and Repositories (06:37)

Building a CRUD Service (04:19)

Building the API layer with Minimal APIs (13:25)

What are Stored Procedures? (02:33)

When to use Stored Procedures (02:52)

Writing a Stored Procedure and Executing it from Dapper (05:10)

Dapper Plus (03:18)

Bulk Insert (02:46)

Bulk Update (04:15)

Upserting Bulk Data with BulkMerge() (07:55)

Bulk Delete (01:33)

Guarding against SQL Injection Attacks (06:31)

Managing Connection Strings (06:01)

Improving Performance with Unbuffered Operations (06:09)

Creating Temporary Tables (05:20)

Using Transactions (08:28)

Conclusion (01:05)

Course Info

Level:
From Zero to Hero
Duration:
3h 20m
Rating (New):
star

Lifetime access

Add to Cart
Dometrain Pro

Want access to all of our courses? Subscribe to Dometrain Pro!

Try it for free!

About the Author

author_img

Nick Proud

Based in the north of the UK where he lives with his wife and daughter, he creates educational YouTube videos on C# and .NET. He is also currently the CTO at NexBotix, an intelligent automation firm delivering software that enhances business processes.

More courses by Nick Proud