public static void AddRecordsAndSave() { using var db = new AW2016Context(); for (int i = 0; i < 1000; i++) { db.ProductCategory.Add(new ProductCategory { Name = $"Test {Guid.NewGuid()}" }); } db.SaveChanges(); }
public static void AddRecordsAndSaveNoBatching() { var builder = new DbContextOptionsBuilder <AW2016Context>(); var connectionString = @"server=.\dev2019;Database=Adventureworks2016;Trusted_Connection=True;"; builder.UseSqlServer(connectionString, options => options.MaxBatchSize(1)); using var db = new AW2016Context(builder.Options); for (int i = 0; i < 1000; i++) { db.ProductCategory.Add(new ProductCategory { Name = $"Test {Guid.NewGuid()}" }); } db.SaveChanges(); }