// Entity Framework Extensions

// Doc: https://entityframework-extensions.net/bulk-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();

            // Add "Customer_C" and "Customer_D"

            // Modify "Customer_A"

            // Remove "Customer_B"

            context.Customers.Add(new Customer() { Code = "Customer_C" });

            context.Customers.Add(new Customer() { Code = "Customer_D" });

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

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

            var resultInfo = new Z.BulkOperations.ResultInfo();

            context.BulkSaveChanges(options => {

                options.UseRowsAffected = true;

                options.ResultInfo = resultInfo;

            });

            FiddleHelper.Dump(resultInfo);

        }

    }

    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; }

    }

}