public void Uses_MaxBatchSize_specified_in_SqlServerOptionsExtension()
{
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlServer("Database=Crunchie", b => b.MaxBatchSize(1));
var typeMapper = TestServiceFactory.Instance.Create <SqlServerTypeMapper>();
var factory = new SqlServerModificationCommandBatchFactory(
new RelationalCommandBuilderFactory(
new FakeDiagnosticsLogger <DbLoggerCategory.Database.Command>(),
typeMapper),
new SqlServerSqlGenerationHelper(
new RelationalSqlGenerationHelperDependencies()),
new SqlServerUpdateSqlGenerator(
new UpdateSqlGeneratorDependencies(
new SqlServerSqlGenerationHelper(
new RelationalSqlGenerationHelperDependencies()),
typeMapper)),
new UntypedRelationalValueBufferFactoryFactory(
new RelationalValueBufferFactoryDependencies(
typeMapper)),
optionsBuilder.Options);
var batch = factory.Create();
Assert.True(batch.AddCommand(new ModificationCommand("T1", null, new ParameterNameGenerator().GenerateNext, false, null)));
Assert.False(batch.AddCommand(new ModificationCommand("T1", null, new ParameterNameGenerator().GenerateNext, false, null)));
}
public void MaxBatchSize_is_optional()
{
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlServer("Database=Crunchie");
var typeMapper = new SqlServerTypeMapper(
new CoreTypeMapperDependencies(),
new RelationalTypeMapperDependencies());
var factory = new SqlServerModificationCommandBatchFactory(
new RelationalCommandBuilderFactory(
new FakeDiagnosticsLogger <DbLoggerCategory.Database.Command>(),
typeMapper),
new SqlServerSqlGenerationHelper(
new RelationalSqlGenerationHelperDependencies()),
new SqlServerUpdateSqlGenerator(
new UpdateSqlGeneratorDependencies(
new SqlServerSqlGenerationHelper(
new RelationalSqlGenerationHelperDependencies()),
typeMapper)),
new UntypedRelationalValueBufferFactoryFactory(
new RelationalValueBufferFactoryDependencies(
typeMapper)),
optionsBuilder.Options);
var batch = factory.Create();
Assert.True(batch.AddCommand(new ModificationCommand("T1", null, new ParameterNameGenerator().GenerateNext, false, null)));
Assert.True(batch.AddCommand(new ModificationCommand("T1", null, new ParameterNameGenerator().GenerateNext, false, null)));
}
public void Uses_MaxBatchSize_specified_in_SqlServerOptionsExtension()
{
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlServer("Database=Crunchie", b => b.MaxBatchSize(1));
var factory = new SqlServerModificationCommandBatchFactory(
new RelationalCommandBuilderFactory(
new FakeSensitiveDataLogger <RelationalCommandBuilderFactory>(),
new DiagnosticListener("Fake"),
new SqlServerTypeMapper(
new RelationalTypeMapperDependencies())),
new SqlServerSqlGenerationHelper(
new RelationalSqlGenerationHelperDependencies()),
new SqlServerUpdateSqlGenerator(
new UpdateSqlGeneratorDependencies(
new SqlServerSqlGenerationHelper(
new RelationalSqlGenerationHelperDependencies())),
new SqlServerTypeMapper(
new RelationalTypeMapperDependencies())),
new UntypedRelationalValueBufferFactoryFactory(
new RelationalValueBufferFactoryDependencies()),
optionsBuilder.Options);
var batch = factory.Create();
Assert.True(batch.AddCommand(new ModificationCommand("T1", null, new ParameterNameGenerator().GenerateNext, p => p.SqlServer())));
Assert.False(batch.AddCommand(new ModificationCommand("T1", null, new ParameterNameGenerator().GenerateNext, p => p.SqlServer())));
}
public void Configuration_can_be_null()
{
var factory = new SqlServerModificationCommandBatchFactory(new SqlServerSqlGenerator(), null);
var batch = factory.Create();
Assert.True(factory.AddCommand(batch, new ModificationCommand(new SchemaQualifiedName("T1"), new ParameterNameGenerator(), p => p.SqlServer())));
Assert.True(factory.AddCommand(batch, new ModificationCommand(new SchemaQualifiedName("T1"), new ParameterNameGenerator(), p => p.SqlServer())));
}
public void SqlServerOptionsExtension_is_optional()
{
var factory = new SqlServerModificationCommandBatchFactory(new SqlServerSqlGenerator());
IDbContextOptions options = new DbContextOptions();
options.RawOptions = new Dictionary <string, string>(StringComparer.OrdinalIgnoreCase);
var batch = factory.Create(options);
Assert.True(factory.AddCommand(batch, new ModificationCommand(new SchemaQualifiedName("T1"), new ParameterNameGenerator(), p => p.SqlServer())));
Assert.True(factory.AddCommand(batch, new ModificationCommand(new SchemaQualifiedName("T1"), new ParameterNameGenerator(), p => p.SqlServer())));
}
public void SqlServerOptionsExtension_is_optional()
{
var factory = new SqlServerModificationCommandBatchFactory(new SqlServerSqlGenerator());
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlServer("Database=Crunchie");
var batch = factory.Create(optionsBuilder.Options);
Assert.True(factory.AddCommand(batch, new ModificationCommand("T1", null, new ParameterNameGenerator(), p => p.SqlServer(), new BoxedValueReaderSource())));
Assert.True(factory.AddCommand(batch, new ModificationCommand("T1", null, new ParameterNameGenerator(), p => p.SqlServer(), new BoxedValueReaderSource())));
}
public void SqlServerOptionsExtension_is_optional()
{
var factory = new SqlServerModificationCommandBatchFactory(new SqlServerUpdateSqlGenerator());
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlServer("Database=Crunchie");
var batch = factory.Create(optionsBuilder.Options, new SqlServerMetadataExtensionProvider());
Assert.True(factory.AddCommand(batch, new ModificationCommand("T1", null, new ParameterNameGenerator(), p => p.SqlServer(), new UntypedValueBufferFactoryFactory())));
Assert.True(factory.AddCommand(batch, new ModificationCommand("T1", null, new ParameterNameGenerator(), p => p.SqlServer(), new UntypedValueBufferFactoryFactory())));
}
public void Uses_MaxBatchSize_specified_in_SqlServerOptionsExtension()
{
var factory = new SqlServerModificationCommandBatchFactory(new SqlServerSqlGenerator());
var optionsBuilder = new EntityOptionsBuilder();
optionsBuilder.UseSqlServer("Database=Crunchie").MaxBatchSize(1);
var batch = factory.Create(optionsBuilder.Options, new SqlServerMetadataExtensionProvider());
Assert.True(factory.AddCommand(batch, new ModificationCommand("T1", null, new ParameterNameGenerator(), p => p.SqlServer(), new UntypedValueBufferFactoryFactory())));
Assert.False(factory.AddCommand(batch, new ModificationCommand("T1", null, new ParameterNameGenerator(), p => p.SqlServer(), new UntypedValueBufferFactoryFactory())));
}
public void MaxBatchSize_configuration_is_optional()
{
var configuration = new Configuration
{
new MemoryConfigurationSource()
};
var factory = new SqlServerModificationCommandBatchFactory(new SqlServerSqlGenerator(), new[] { configuration });
var batch = factory.Create();
Assert.True(factory.AddCommand(batch, new ModificationCommand(new SchemaQualifiedName("T1"), new ParameterNameGenerator(), p => p.SqlServer())));
Assert.True(factory.AddCommand(batch, new ModificationCommand(new SchemaQualifiedName("T1"), new ParameterNameGenerator(), p => p.SqlServer())));
}
public void MaxBatchSize_is_optional()
{
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlServer("Database=Crunchie");
var factory = new SqlServerModificationCommandBatchFactory(
new RelationalCommandBuilderFactory(new SqlServerTypeMapper()),
new SqlServerUpdateSqlGenerator(new SqlServerSqlGenerator()),
new UntypedRelationalValueBufferFactoryFactory(),
optionsBuilder.Options);
var batch = factory.Create();
Assert.True(batch.AddCommand(new ModificationCommand("T1", null, new ParameterNameGenerator(), p => p.SqlServer())));
Assert.True(batch.AddCommand(new ModificationCommand("T1", null, new ParameterNameGenerator(), p => p.SqlServer())));
}
public void Uses_MaxBatchSize_specified_in_configuration()
{
var configuration = new Configuration
{
new MemoryConfigurationSource(
new Dictionary <string, string>
{
{ "Data:SqlServer:MaxBatchSize", "1" }
})
};
var factory = new SqlServerModificationCommandBatchFactory(new SqlServerSqlGenerator(), new[] { configuration });
var batch = factory.Create();
Assert.True(factory.AddCommand(batch, new ModificationCommand(new SchemaQualifiedName("T1"), new ParameterNameGenerator(), p => p.SqlServer())));
Assert.False(factory.AddCommand(batch, new ModificationCommand(new SchemaQualifiedName("T1"), new ParameterNameGenerator(), p => p.SqlServer())));
}
public void MaxBatchSize_is_optional()
{
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlServer("Database=Crunchie");
var typeMapper = new SqlServerTypeMappingSource(
TestServiceFactory.Instance.Create <TypeMappingSourceDependencies>(),
TestServiceFactory.Instance.Create <RelationalTypeMappingSourceDependencies>());
var logger = new FakeRelationalCommandDiagnosticsLogger();
var factory = new SqlServerModificationCommandBatchFactory(
new ModificationCommandBatchFactoryDependencies(
new RelationalCommandBuilderFactory(
new RelationalCommandBuilderDependencies(
typeMapper,
new SqlServerExceptionDetector())),
new SqlServerSqlGenerationHelper(
new RelationalSqlGenerationHelperDependencies()),
new SqlServerUpdateSqlGenerator(
new UpdateSqlGeneratorDependencies(
new SqlServerSqlGenerationHelper(
new RelationalSqlGenerationHelperDependencies()),
typeMapper)),
new TypedRelationalValueBufferFactoryFactory(
new RelationalValueBufferFactoryDependencies(
typeMapper, new CoreSingletonOptions())),
new CurrentDbContext(new FakeDbContext()),
logger),
optionsBuilder.Options);
var batch = factory.Create();
Assert.True(batch.AddCommand(CreateModificationCommand("T1", null, false)));
Assert.True(batch.AddCommand(CreateModificationCommand("T1", null, false)));
}
