Entity Framework Performance NoTracking

From Logic Wiki
Jump to: navigation, search


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