Entity Framework Bulk Merge Discover who support this features
Introduction
BulkMerge allows you to improve EF performance by merging multiple entities with bulk operations.
Why BulkMerge?
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);
Supported Libraries
Library | Type | EF Version | Support | Doc | Features |
---|---|---|---|---|---|
Z.EntityFramework.Extensions | PRO | EF6 | < 1 Day | Yes | Bulk SaveChanges Bulk Insert Bulk Update Bulk Delete Bulk Merge |
ZZZ Projects