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