Better Object Mapping in .NET with Dapper
summary
Dapper is presented as a focused micro ORM that maps SQL result sets to C# objects with gutsy practical demos using AdventureWorks and SqlClient The demo returns 19,000 rows automatically mapped, filters to 60 Kevins via parameterized where clauses, shows inserts in a loop of 10,000, calls stored procedures by setting CommandType, and demonstrates transactions that require manually opening the connection Uses query async / execute async and dynamic parameters and everything shown runs end to end during the session
AI-written summary · about
chapters (8)
- 0:00Introduction
- 2:07What is Object Mapping?
- 6:02Dapper
- 11:01Scenario's and Demo's
- 25:38QueryFirst or QueryFirstOrDefault
- 27:22Insert/update/delete
- 31:55Stored procedures
- 40:36Questions and Answers
related talks
45m.NET: SQL vs ORM - Will Dapper Resolve the Age-Old Debate?
01h 00mPitfalls of relational DB access in .NET: rethinking micro-ORMs
01h 11mMigrating from SQL to NoSQL with .NET and Dapper
47mFaster, Better ORM with DataMapper
41mAn Object Oriented Approach to Data Driven Software Development
08h 53m.NET Days Online. Day 1
01h 02mUnlocking the Full Potential: The Harmonious Dance of EF Core and SQL Server
32mBuilding .NET software with focus on performance and scalability