Entity Framework Extensions Update from Query

Definition

UPDATE all rows from the database using a LINQ Query without loading entities in the context.

An UPDATE statement is built using the LINQ expression and directly executed in the database.

// UPDATE all customers that are inactive for more than two years
var date = DateTime.Now.AddYears(-2);
context.Customers
    .Where(x => x.IsActive && x.LastLogin < date)
    .UpdateFromQuery(x => new Customer {IsActive = false});
	
// UPDATE customers by id
context.Customers.Where(x => x.ID == userId).UpdateFromQuery(x => new Customer {IsActive = false});

Try it in EF Core | Try it in EF6

Purpose

Updating entities using SaveChanges normally requires loading them first in the ChangeTracker. These additional round-trips are often not necessary.

UpdateFromQuery gives you access to directly execute an UPDATE statement in the database and provides a HUGE performance improvement.

Performance Comparisons