private static void MultipleAddTest() { System.Console.WriteLine("---------------"); System.Console.WriteLine("Multiple Add Test"); string connectionString = "Server=127.0.0.1,1433;Database=ZFDb;User Id=sa;Password=P@ssw0rd"; var optionsBuilder = new DbContextOptionsBuilder<MyContext>(); var loggerFactory = new LoggerFactory(); loggerFactory.AddProvider(new ConsoleLoggerProvider((category, level) => level == LogLevel.Information, true)); optionsBuilder .UseLoggerFactory(loggerFactory) .UseSqlServer(connectionString); var customerFaker = new CustomerFaker(); var customers = customerFaker.GenerateLazy(100000); using(var context = new MyContext(optionsBuilder.Options)) { foreach(var customer in customers) { context.Customers.Add(customer); } context.SaveChanges(); } }