Entity Framework - Bulk Merge
BulkMerge allows you to improve EF performance by merging multiple entities with bulk operations.
For HUGE performance gains, Entity Framework makes one database round-trip for each entity to insert/update.
So if you want to modify 10,000 entities, 10,000 database round trip will be required which is INSANELY slow. To use BulkMerge, you will need to use a third-party library.
|Operations||1,000 Entities||2,000 Entities||5,000 Entities|
|BulkMerge||65 ms||80 ms||110 ms|
|SaveChanges||1,000 ms||2,000 ms||5,000 ms|
Google Related Searches
StackOverflow Related Questions
- Entity Framework update/insert multiple entities
- Insert/Update bulk data to sql table in entity framework
// using Z.EntityFramework.Extensions; // Don't forget to include this. // Easy to use context.BulkMerge(list); // Easy to customize context.BulkMerge(list, bulk => bulk.BatchSize = 100);
|Z.EntityFramework.Extensions||PRO||EF6||< 1 Day||Yes||Bulk SaveChanges