Entity Framework Tutorial BulkSaveChanges
Introduction
BulkSaveChanges allows you to improve EF performance by saving multiple entities with bulk operations.
Why BulkSaveChanges?
For HUGE performance gains, Entity Framework 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 database round trip will be required which is INSANELY slow. To use BulkSaveChanges, you will need to use a third-party library.
| Operations | 1,000 Entities | 2,000 Entities | 5,000 Entities |
|---|---|---|---|
| BulKSaveChanges | 90 ms | 150 ms | 350 ms |
| SaveChanges | 1,000 ms | 2,000 ms | 5,000 ms |
Google Related Searches
- Entity Framework Bulk Operations
- Entity Framework SaveChanges Performance
- Entity Framework SaveChanges Slow
StackOverflow Related Questions
- Fastest way of inserting many parent and child records
- Bulk Insert in Entity Framework v6.1
- C# & EF: bulkinsert related objects
- Entity framework 6 code first Many to many insert slow
- Insert thousands of many to many links to the DB quickly
- Entity Framework Bulk Insert Throws KeyNotFoundException error
- Bulk insert from a csv file using Entity Framework
// using Z.EntityFramework.Extensions; // Don't forget to include this. // Easy to use context.BulkSaveChanges(); // Easy to customize context.BulkSaveChanges(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 |
