JonathanMagnan

var ctx = new EntitiesContext();

// Easy to use
ctx.BulkMerge(list);

// Easy to customize
context.BulkDelete(customers, 
   bulk => bulk.ColumnPrimaryKeyExpression = customer => customer.Code; });

JonathanMagnan

// UPDATE all customers that are inactive for more than two years
context.Customers
    .Where(x => x.Actif && x.LastLogin < DateTime.Now.AddYears(-2))
    .UpdateFromQuery(x => new Customer {Actif = false});

JonathanMagnan

// DELETE all customers that are inactive for more than two years
context.Customers
    .Where(x => x.LastLogin < DateTime.Now.AddYears(-2))
    .DeleteFromQuery();

JonathanMagnan

List<AuditEntry> auditEntries = new List<AuditEntry>();
using (var ctx = new EntitiesContext())
{
    ctx.BulkSaveChanges(list, operation =>
    {
        operation.UseAudit = true;
        operation.BulkOperationExecuted = bulkOperation => auditEntries.AddRange(bulkOperation.AuditEntries);
    });
}

JonathanMagnan

context.BulkSaveChanges(operation =>
{
   operation.BatchSize = 100;
});

JonathanMagnan

using (var ctx = new EntitiesContext())
{
    ctx.BulkSaveChanges(operation =>
    {
        operation.BulkOperationExecuting = bulkOperation => { /* configuration */ };
    });
}

JonathanMagnan

StringBuilder logger = new StringBuilder();
using (var ctx = new EntitiesContext())
{
    ctx.BulkSaveChanges(operation =>
    {
        operation.Log += s => logger.AppendLine(s);
    });
}

JonathanMagnan

context.BulkSaveChanges(operation =>
{
   bulk.TemporaryTableBatchByTable = 5;
});

JonathanMagnan

using (var ctx = new EntitiesContext())
{
    ctx.BulkSaveChanges(operation =>
    {
        operation.RetryCount = 3;
    });
}

JonathanMagnan

context.BulkSaveChanges(operation =>
{
   bulk.SqlBulkCopyOptions = SqlBulkCopyOptions.Default | SqlBulkCopyOptions.TableLock;
});