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 20m 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
Why Use the Reader?
The ExecuteReader Method
One-To-Many Relationships in Dapper
Many-To-Many Relationships in Dapper
What is CRUD?
The Repository Pattern
Building Models and Repositories
Building a CRUD Service
Building the API layer with Minimal APIs
What are Stored Procedures?
When to use Stored Procedures
Writing a Stored Procedure and Executing it from Dapper
Dapper Plus
Bulk Insert
Bulk Update
Upserting Bulk Data with BulkMerge()
Bulk Delete
Guarding against SQL Injection Attacks
Managing Connection Strings
Improving Performance with Unbuffered Operations
Creating Temporary Tables
Using Transactions
Conclusion
Course Details
Level From Zero to Hero
Duration 3h 20m
Rating 
Pro Only
$41.66 /month
when billed annually
Subscribe to Pro- Access to all courses
- Certificate of completion
Meet Your Instructor
Nick Proud
© 2025 Dometrain. All rights reserved.
