Entity Framework Extensions Reduce your save times by up to 95% - Easy to Use, Easy to Customize

// 100+ options to customize your saves

// Insert only customers that don't exist with a custom key
context.BulkInsert(customers, options => { 
    options.InsertIfNotExists = true;
    options.ColumnPrimaryKeyExpression = customer => customer.Code;
});

// Merge (Upsert) with related child entities (Order, OrderItem)
context.BulkMerge(orders, options => {
    options.IncludeGraph = true;
});

// Just add "Bulk" prefix to "SaveChanges()"

// Easy to use
context.BulkSaveChanges();

// Easy to customize
context.BulkSaveChanges(options => options.BatchSize = 1000);

// Supports: 
//    - Unlimited number of items
//    - Multiple DataSources: Basic Type, Entity Type, Anonymous Type, Expando
//    - Surrogate keys (joins on multiple properties)

// Return customers from the database matching customers from the list
var databaseCustomers = context.Customers.WhereBulkContains(listCustomers);

// Return customers from the list matching customers from the database
// Additionally, use a surrogate key
var sourceCustomers = context.Customers
    .WhereBulkContainsFilterList(listCustomers, x => new { x.Email, x.Name });

var dateToDeactivate = DateTime.Now.AddYears(-2);

// UPDATE active customers who haven’t logged in recently
context.Customers
    .Where(x => x.IsActive && x.LastLogin < dateToDeactivate)
    .UpdateFromQuery(x => new Customer { IsActive = false });

// INSERT inactive customers into a backup table
context.Customers
    .Where(x => !x.IsActive && !x.Invoices.Any())
    .InsertFromQuery("bck_Customers",
        x => new { x.CustomerID, x.Code, x.Name, x.Email, x.LastLogin });

// DELETE inactive customers
context.Customers
    .Where(x => !x.IsActive && !x.Invoices.Any())
    .DeleteFromQuery();