Entity Framework Performance NoTracking
From Logic Wiki
With and Without Tracking
using(Entities context = new Entities())
{
var employeeWith = context.Employees.AsNoTracking().ToList();
var employeeWithout = context.Employees.ToList();
}
using(Entities context = new Entities())
{
var employee = context.Employees.AsNoTracking().ToList();
var employee2 = context.Employees
.Where(p => p.EmployeeId >= 3)
.AsNoTracking().ToList();
}
it's faster without tracking