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:
About the Author
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© 2025 Dometrain. All rights reserved.
