I ran a full BenchmarkDotNet suite comparing:
EF Core (Tracked ✅ / NoTracking ❌)
Dapper (Raw SQL, no ORM fluff)
We tested:
- SelectById
- SelectMany (1000 rows)
- Insert speed
- Memory usage & allocations
💥 Results?
Dapper crushed EF in insert performance (65x faster)
Tracking in EF adds more overhead than you think
This is a real-world test, not just theory.
📹 Watch the video and see the numbers for yourself.