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