JonathanMagnan

using (var ctx = new CustomerContext())
{
    foreach(var line in lines)
    {
        var customer = new Customer();
        // ...code...
        
        // DetectChanges is invoked every time you call Add
        ctx.Customers.Add(customer);
    }

JonathanMagnan

using (var ctx = new CustomerContext())
{
    foreach(var line in lines)
    {
        var customer = new Customer();
        // ...code...
        ctx.Customers.Add(customer);
    }
    
    ctx.SaveChanges();

JonathanMagnan

using (var ctx = new CustomerContext())
{
    // 1. SPLIT the queries in multiple smaller queries
    var customers = ctx.Customers
                       .Include(x => x.Orders.Select(y => y.Items.Select(z => z.Product))
                       .ToList();
                    
    var customers = ctx.Customers
                       .Include(x => x.Payments.Select(y => y.Items)
                       .ToList();

JonathanMagnan

using (var ctx = new CustomerContext())
{
    List<Customer> customers = new List<Customer>();
    
    foreach(var line in lines)
    {
        var customer = new Customer();
        // ...code...
        
        customers.Add(customer);

JonathanMagnan

using (var ctx = new CustomerContext())
{
    List<Customer> customers = new List<Customer>();
    
    foreach(var line in lines)
    {
        var customer = new Customer();
        // ...code...
        
        customers.Add(customer);

JonathanMagnan

// using Z.EntityFramework.Plus; // Don't forget to include this.

// AutoSave audit in a database
AuditManager.DefaultConfiguration.AutoSavePreAction = (context, audit) =>
         (context as EntityContext).AuditEntries.AddRange(audit.Entries);

var ctx = new EntityContext();
// ... ctx changes ...

var audit = new Audit();

JonathanMagnan

// using Z.EntityFramework.Plus; // Don't forget to include this.

// DELETE all users inactive for 2 years
ctx.Users.Where(x => x.LastLoginDate < DateTime.Now.AddYears(-2))
         .Delete();

// DELETE using a BatchSize
ctx.Users.Where(x => x.LastLoginDate < DateTime.Now.AddYears(-2))
         .Delete(x => x.BatchSize = 1000);

JonathanMagnan

// using Z.EntityFramework.Plus; // Don't forget to include this.

// UPDATE all users inactive for 2 years
ctx.Users.Where(x => x.LastLoginDate < DateTime.Now.AddYears(-2))
         .Update(x => new User() { IsSoftDeleted = 1 });

JonathanMagnan

// using Z.EntityFramework.Extensions; // Don't forget to include this.

// Easy to use
context.BulkDelete(list);

// Easy to customize
context.BulkDelete(list, bulk => bulk.BatchSize = 100);

JonathanMagnan

// using Z.EntityFramework.Extensions; // Don't forget to include this.

// Easy to use
context.BulkInsert(list);

// Easy to customize
context.BulkInsert(list, bulk => bulk.BatchSize = 100);