public void Keys_generated_in_batches(int count, int expected) { var loggerFactory = new TestSqlLoggerFactory(); var serviceProvider = new ServiceCollection() .AddEntityFramework() .AddSqlServer() .ServiceCollection() .AddSingleton <ILoggerFactory>(loggerFactory) .BuildServiceProvider(); using (var context = new ConfiguredChipsContext(serviceProvider)) { context.Database.EnsureCreated(); for (var i = 0; i < count; i++) { context.Chips.Add(new KettleChips { BestBuyDate = DateTime.Now, Name = "Doritos Locos Tacos " + i }); } context.SaveChanges(); } Assert.Equal(expected, CountSqlLinesContaining("SELECT NEXT VALUE FOR")); }
public void Constructed_update_statement_uses_commandTimeout_configured_in_Context() { var serviceProvider = new ServiceCollection() .AddEntityFramework() .AddSqlServer() .ServiceCollection() .AddSingleton <IModificationCommandBatchFactory, TestSqlServerModificationCommandBatchFactory>() .BuildServiceProvider(); using (var context = new ConfiguredChipsContext(serviceProvider)) { context.Database.EnsureCreated(); context.Chips.Add(new KettleChips { BestBuyDate = DateTime.Now, Name = "Doritos Locos Tacos" }); context.SaveChanges(); Assert.Equal(77, GlobalCommandTimeout); } }
public void Keys_generated_in_batches(int count, int expected) { var loggerFactory = new TestSqlLoggerFactory(); var serviceProvider = new ServiceCollection() .AddEntityFramework() .AddSqlServer() .ServiceCollection() .AddInstance<ILoggerFactory>(loggerFactory) .AddSingleton<SqlServerModificationCommandBatchFactory, TestSqlServerModificationCommandBatchFactory>() .BuildServiceProvider(); using (var context = new ConfiguredChipsContext(serviceProvider, "KettleChips")) { context.Database.EnsureCreated(); for (int i = 0; i < count; i++) { context.Chips.Add(new KettleChips { BestBuyDate = DateTime.Now, Name = "Doritos Locos Tacos " + i }); } context.SaveChanges(); } Assert.Equal(expected, CountSqlLinesContaining("SELECT NEXT VALUE FOR")); }
public void Constructed_update_statement_uses_commandTimeout_overriding_configured_in_context() { var serviceProvider = new ServiceCollection() .AddEntityFramework() .AddSqlServer() .ServiceCollection() .AddSingleton<SqlServerModificationCommandBatchFactory, TestSqlServerModificationCommandBatchFactory>() .BuildServiceProvider(); using (var context = new ConfiguredChipsContext(serviceProvider, "KettleChips")) { context.Database.EnsureCreated(); context.Database.AsRelational().Connection.CommandTimeout = 88; context.Chips.Add(new KettleChips { BestBuyDate = DateTime.Now, Name = "Doritos Locos Tacos" }); context.SaveChanges(); Assert.Equal(88, globalCommandTimeout); } }