30% OFF - 10th Anniversary discount on new purchases until December 15 with code: ZZZANNIVERSARY10
Entity Framework Extensions Ignore OnUpdateMatched AndCondition Expression
Description
The IgnoreOnUpdateMatchedAndConditionExpression
is the inverse of UpdateMatchedAndConditionExpression
.
- The
UpdateMatchedAndConditionExpression
allows you to perform the bulk update operation if the specified property value is not equal to the database value. - So by default, all columns are included in
IgnoreOnUpdateMatchedAndConditionExpression
but not the one you choose to ignore.
The following example updates all those records in which the CreatedDate
property is equal to database value and ignores the specified properties in IgnoreOnUpdateMatchedAndConditionExpression
if their value is equal to the database or not.
using (var context = new EntityContext()) { var customers = context.Customers.ToList(); customers.ForEach(x => { x.Name += "_Updated"; x.Description += "_Updated"; x.ModifiedDate = DateTime.Now; x.IsActive = false; }); customers.Last().CreatedDate = DateTime.Now; context.BulkUpdate(customers, options => { options.IgnoreOnUpdateMatchedAndConditionExpression = c => new { c.Name, c.Description, c.ModifiedDate, c.IsActive }; }); }
- It will update all records except for the last record because the
CreatedDate
property is updated.
ZZZ Projects