Welcome
What will you learn in this course?
Who is the course for and prerequisites
From Zero to Hero: Dapper in .NET
Learn how to use Dapper, the most popular .NET ORM
About This Course
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.
Course Curriculum
3h 22m 11 sections
What is Dapper?
What is an ORM?
What is a Micro-ORM?
Why use Dapper?
Installing Dapper
Dapper vs Entity Framework
Querying Single Columns with Execute Scalar
Querying Single Rows
Querying Multiple Rows and Values
Retrieving Data Asynchronously
Inserting Data
Deleting Records
Updating Records
What are Stored Procedures?
When to use Stored Procedures
Writing a Stored Procedure and Executing it from Dapper
Why Use the Reader?
The ExecuteReader Method
One-To-Many Relationships in Dapper
Many-To-Many Relationships in Dapper
Dapper Plus
Bulk Insert
Bulk Update
Bulk Delete
Upserting Bulk Data with BulkMerge()
What is CRUD?
The Repository Pattern
Building Models and Repositories
Building a CRUD Service
Building the API layer with Minimal APIs
Guarding against SQL Injection Attacks
Managing Connection Strings
Improving Performance with Unbuffered Operations
Creating Temporary Tables
Using Transactions
Conclusion
Meet Your Instructor
Nick Proud
© 2026 Dometrain. All rights reserved.
