// Entity Framework Extensions

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

​

// @nuget: Microsoft.EntityFrameworkCore.SqlServer

// @nuget: Z.EntityFramework.Extensions.EFCore

​

​

using System.Collections.Generic;

using System.Linq;

using Microsoft.Data.SqlClient;

using Microsoft.EntityFrameworkCore;

​

public class Program

{

    public static void Main()

    {

        using (var context = new EntityContext())

        {

            context.Database.EnsureCreated();

        }

        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"          

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

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

            // Easy to use

            context.BulkSaveChanges();

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

            // ADD 200x "Customer_I"

            var listToAdd = new List<Customer>();

            for(int i = 0; i < 200; i++)

            {

                listToAdd.Add(new Customer() { Code = "Customer_" + i });

            }

            context.Customers.AddRange(listToAdd);

            // Easy to customize

            context.BulkSaveChanges(options => options.BatchSize = 100);

            FiddleHelper.WriteTable("3 - 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.SaveChanges();

        }

    }

    public class EntityContext : DbContext

    {

        public EntityContext() 

        {

        }

​

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

        {

            optionsBuilder.UseSqlServer(new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()));

​

            base.OnConfiguring(optionsBuilder);

        }

        public DbSet<Customer> Customers { get; set; }

    }

​

    public class Customer

    {

        public int CustomerID { get; set; }

        public string Code { get; set; }

    }

}