Entity Framework Extensions UpdateMatched AndOneNotCondition Expression


The UpdateMatchedAndOneNotConditionExpression allows you to perform the bulk update operation if the specified property value is not equal to the database value.

The following example updates all those records in which ModifiedDate value is not equal to the database value.

using (var context = new EntityContext())
    var customers = context.Customers.ToList();
    customers.ForEach(x => { x.Name += "_Updated"; x.Description += "_Updated"; x.IsActive = false; });
    customers.Take(2).ToList().ForEach(x => { x.ModifiedDate = DateTime.Now; });

    context.BulkUpdate(customers, options => 
        options.UpdateMatchedAndOneNotConditionExpression = c => new {c.CustomerID, c.ModifiedDate };

Try it: EF Core | EF6

  • It will update all the records except for the last record.
  • The ModifiedDate property is only updated for the first two records and not for the last record.

Last updated: 2023-03-01