Entity Framework Extensions - Bulk Merge
Allow you to perform a MERGE (Insert/Update) operation.
|Operations||1,000 Entities||2,000 Entities||5,000 Entities|
|SaveChanges||1,000 ms||2,000 ms||5,000 ms|
|BulkMerge||65 ms||80 ms||110 ms|
SaveChanges makes one database round-trip for each entity to insert/update/delete. So if you want to save (add, modify or remove) 10,000 entities, 10,000 databases round trip will be required which are INSANELY slow.
Bulk Operations save entities in bulk to reduce the number of database round-trip required.