using Microsoft.EntityFrameworkCore;
using System.Collections.Generic;
using Microsoft.Data.SqlClient;
public static void Main()
using (var context = new EntityContext())
context.Database.EnsureCreated();
using (var context = new EntityContext())
var list = context.Customers.ToList();
FiddleHelper.WriteTable("1 - Customers Before", context.Customers.AsNoTracking());
list.Single(x => x.Code == "Customer_A").Code = "Customer_A_Modified";
context.Customers.Remove(list.Single(x => x.Code == "Customer_B"));
context.BulkSaveChanges();
FiddleHelper.WriteTable("2 - Customers After", context.Customers.AsNoTracking());
var listToAdd = new List<Customer>();
for(int i = 0; i < 200; i++)
listToAdd.Add(new Customer() { Code = "Customer_" + i });
context.Customers.AddRange(listToAdd);
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" });
public class EntityContext : DbContext
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
optionsBuilder.UseSqlServer(new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()));
base.OnConfiguring(optionsBuilder);
public DbSet<Customer> Customers { get; set; }
public int CustomerID { get; set; }
public string Code { get; set; }