Entity Framework Extensions SynchronizeKeepIdentity


The BulkOperation.SynchronizeKeepIdentity sets if the source identity value should be preserved on Synchronize. When not specified, identity values are assigned by the destination.

In the following example, the SynchronizeKeepIdentity is enabled and the specified value for IdentityInt column will be stored in the database instead of the database generated values on Synchronize operation.

using (var context = new EntityContext())
    var list = context.Customers.ToList();
    list.ForEach(x => x.Name += "_Synchronize" );
    list.ForEach(x => x.IdentityInt += 100 );
    list.Add( new Customer() { CustomerID = 3, IdentityInt = 4, Name ="Customer_C" });

    context.BulkMerge(list, options => options.SynchronizeKeepidentity = true);

Try it: EF Core | EF6


The SynchronizeKeepIdentity option let you keep the source identity value when synchronizing.

For example, when importing a file, you may want to keep the value specified.

Last updated: 2023-03-01