.NET: SQL vs ORM - Will Dapper Resolve the Age-Old Debate?
summary
Comparison of data-access approaches in .NET Core: Entity Framework Core (ORM, Database/Code First) versus handwritten SQL and stored procedures, and whether lightweight micro-ORM Dapper is a better fit for some queries. Covers how query-writing style in EF Core affects results and demonstrates using .NET Core, EF Core, Dapper and SQL Server to illustrate trade-offs.
AI-written summary · about
related talks
01h 00mPitfalls of relational DB access in .NET: rethinking micro-ORMs
54mBetter Object Mapping in .NET with Dapper
01h 01mEntity Framework Core Unchained Getting the Best Performance from Your ORM
41mWhy Should I Know SQL and Databases When I Have an ORM?
01h 10mModern Data Applications with Entity Framework 7
01h 00mGetting the best out of Entity Framework Core
49mIs There an ORM Better Than SwiftData?
50mORM – the tip of an iceberg