Entity Framework Core Performance Tuning: N+1 Queries, Eager Loading, and Pagination (2026)
Entity Framework Core makes database interactions feel natural in C#, but that convenience hides real performance costs. The most damaging bugs are silent: queries that execute hundreds of times when one would suffice. This guide covers the patterns that actually perform in production.
The N+1 Problem and Eager Loading
This query fires one query for orders, then one query per order to fetch customers—dangerous at scale:
varorders=await_db.Orders.ToListAsync();
foreach(varorderinorders)
{
varcustomer=order.Customer.Name;// Lazy load fires here
}
Instead, eager-load the related data:
varorders=await_db.Orders
.Include(o=>o.Customer)
.ToListAsync();
For complex relationships, use Select projection to fetch only what you need:
varorders=await_db.Orders
.Select(o=>newOrderDto
{
Id=o.Id,
Total=o.Total,
CustomerName=o.Customer.Name
})
.ToListAsync();
Pagination Without Loading Everything
Skip/Take generates SQL's OFFSET/LIMIT, keeping memory usage constant regardless of total rows:
varpage=1;
varorders=await_db.Orders
.OrderByDescending(o=>o.CreatedAt)
.Skip((page-1)*pageSize)
.Take(pageSize)
.ToListAsync();
Batch Operations for Bulk Updates
EF Core translates this into 1000 separate UPDATE statements—a nightmare:
varitems=await_db.Items.ToListAsync();
foreach(variteminitems)
{
item.Status="archived";
}
await_db.SaveChangesAsync();
Instead, batch the update:
await_db.Items
.Where(i=>i.CreatedBefore<DateTime.UtcNow.AddYears(-1))
.ExecuteUpdateAsync(s=>s.SetProperty(i=>i.Status,"archived"));
Disable Tracking for Read-Only Queries
EF Core tracks every entity returned so it can detect changes on SaveChanges(). For read-only queries, this is wasted memory and CPU:
.AsNoTracking()// Tells EF not to track changes
.ToListAsync();
Optimizing database queries is half the battle—the other half is knowing which patterns scale. This is the kind of architecture work I help teams tackle as part of custom software development engagements where performance matters.