We are starting a new .NET 8 project with SQL Server. Some people on the team say EF Core is too slow and want Dapper. Which should we choose?
We are starting a new .NET 8 project with SQL Server. Some people on the team say EF Core is too slow and want Dapper. Which should we choose?
Both are good, and they solve different problems.
For most business applications EF Core is fast enough, especially with AsNoTracking() on read queries. The usual slowness comes from loading too much data or from N+1 queries, not from EF itself.
A common and healthy mix is EF Core for writes and general queries, and Dapper (or raw SQL) for a few heavy reports or bulk operations. Measure with real data before deciding the team needs to avoid an ORM.