// Entity Framework Extensions

// Doc: https://entityframework-extensions.net/batch-savechanges

// @nuget: Z.EntityFramework.Extensions

// @nuget: EntityFramework

using System;

using System.Collections.Generic;

using System.Data.Entity;

using System.Linq;

​

public class Program

{

    public static void Main()

    {

        GenerateCustomers();

        using (var context = new EntityContext())

        {

            var list = context.Customers.ToList();

            FiddleHelper.WriteTable("1 - Customers Before", context.Customers.AsNoTracking());

            // Modify "Customer_A"

            // Remove "Customer_B"

            // ADD "Customer_C"

            list.Single(x => x.Code == "Customer_A").Code = "Customer_A_Modified";

            context.Customers.Remove(list.Single(x => x.Code == "Customer_B"));

            context.Customers.Add(new Customer()

            {Code = "Customer_C"});

            context.BatchSaveChanges();

            FiddleHelper.WriteTable("2 - Customers After", context.Customers.AsNoTracking());

        }

    }

​

    public static void GenerateCustomers()

    {

        using (var context = new EntityContext())

        {

            context.Customers.Add(new Customer()

            {Code = "Customer_A"});

            context.Customers.Add(new Customer()

            {Code = "Customer_B"});

            context.BatchSaveChanges();

        }

    }

​

    public class EntityContext : DbContext

    {

        public EntityContext(): base(FiddleHelper.GetConnectionStringSqlServer())

        {

        }

​

        public DbSet<Customer> Customers

        {

            get;

            set;

        }

    }

​

    public class Customer

    {

        public int CustomerID

        {

            get;

            set;

        }

​

        public string Code

        {

            get;

            set;

        }

    }

}