Entity Framework Bulk Update Library
Entity Framework Bulk Update library allow you to improve EF performance by updating multiples entities with bulk operations.
Why using Bulk Update with Entity Framework?
For HUGE performance gains.
Entity Framework makes one database round-trip for each entity to update.
So if you want to modify 10,000 entities, 10,000 database round trip will be required which is INSANELY slow.
|Operations||1,000 Entities||2,000 Entities||5,000 Entities|
|BulkUpdate||50 ms||55 ms||65 ms|
|SaveChanges||1,000 ms||2,000 ms||5,000 ms|
Google – Related Searches
Stack Overflow – Related Questions
- WebAPI EF update 30,000 rows of data is very slow
- EF 6 performance while updating multiple records with different values in same table
- Properly and efficiently update hundreds of records in sql server db table from .net c# application loop
|// using Z.EntityFramework.Extensions; // Don't forget to include this.|
|// Easy to use|
|// Easy to customize|
|context.BulkUpdate(list, bulk => bulk.BatchSize = 100);|