Bulk Delete (Enterprise Feature)
DELETE all entities from the database.
All rows that match the entity key are
DELETED from the database.
This feature is provided by Z.EntityFramework.Extensions that's used by more than 2000 customers all over the world.
// Easy to use context.BulkDelete(list); // Easy to customize context.BulkDelete(customers, options => options.ColumnPrimaryKeyExpression = customer => customer.Code);
Deleting entities using a custom key from file importation is a typical scenario.
ChangeTracker being outstanding to track what's modified, it lacks in term of scalability and flexibility.
SaveChanges requires one database round-trip for every entity to
delete. So if you need to
delete 10000 entities, then 10000 database round-trips will be performed which is INSANELY slow.
BulkDelete in counterpart offers great customization and requires the minimum database round-trips as possible.
|Operations||1,000 Entities||2,000 Entities||5,000 Entities|
|SaveChanges||1,000 ms||2,000 ms||5,000 ms|
|BulkDelete||45 ms||50 ms||60 ms|