Roadmap › 1. .NET › Step 16
Dp
Dapper — The Micro-ORM from Basics to Advanced
What Dapper is and how it works inside, Query/QueryFirst/QuerySingle/Execute, parameters and SQL injection safety, stored procedures and output parameters, multi-mapping joins, QueryMultiple, transactions, bulk inserts and table-valued parameters, async and buffering, custom type handlers, DynamicParameters, repository and unit-of-work patterns, Dapper vs EF Core vs ADO.NET, performance and testing.
Interview priority:★ Must know High priority — asked in almost every interview, learn firstMedium asked regularlyLow good to know
Module 1: Dapper Basics
- 1.Setup and the core methodsBasic ★ Must know
- 2.Parameters, SQL injection and IN listsBasic ★ Must know
- 3.Stored procedures, output parameters and return valuesIntermediate ★ Must know
Module 2: Advanced Queries
- 4.Multi-mapping — joins into object graphsIntermediate ★ Must know
- 5.QueryMultiple, transactions and bulk operationsIntermediate ★ Must know
- 6.Buffering, streaming, type handlers and dynamic resultsIntermediate Medium
Module 3: Dapper in Real Applications
- 7.Repository, unit of work and connection management in ASP.NET CoreIntermediate ★ Must know
- 8.Performance, testing and choosing Dapper vs EF CoreAdvanced Medium
Next course in the roadmap: 17. ASP.NET Web Forms — Page Life Cycle, ViewState, Controls and State Management →