Entity Framework Classic Bulk SaveChanges

Description

The EF Bulk SaveChanges feature lets you save thousands of entities in your database efficiently.

This feature is provided by the library EF Extensions (Included with EF Classic). EF Extensions is used by over 2000 customers all over the world and supports all Entity Framework versions (EF4, EF5, EF6, EF Core, EF Classic).

context.Customers.AddRange(listToAdd); // add
context.Customers.RemoveRange(listToRemove); // remove
listToModify.ForEach(x => x.DateModified = DateTime.Now); // modify

// Easy to use
context.BulkSaveChanges();

// Easy to customize
context.BulkSaveChanges(bulk => bulk.BatchSize = 100);

Try it: NET Core | NET Framework

Performance Comparison

Try it: NET Core | NET Framework

HINT:

Performance may differ from a database to another. A lot of factors might affect the benchmark time such as index, column type, latency, throttling, etc.

Why BulkSaveChanges is faster than SaveChanges?

Using the ChangeTracker to detect and persist changes automatically is great! However, it leads very fast to some problems when multiple entities need to be saved.

SaveChanges method makes a database round-trip for every change. So, if you need to insert 10000 entities, then 10000 database round-trips will be performed which is INSANELY slow.

BulkSaveChanges works exactly like SaveChanges but reduces the number of database round-trips required to help significantly improve the performance.

Why BulkSaveChanges(false) is faster than BulkSaveChanges?

The BulkSaveChanges method uses a lot of methods coming from the Entity Framework. When passing false in parameter, some logic such as identity propagation uses custom logic that has been optimized. Learn more about EF Extensions - Improve BulkSaveChanges

Documentation

BatchSaveChanges

Methods

Learn more

More documentation can be found here: EF Extensions - Bulk SaveChanges