public void CanCreateSchema()
{
var mapper = new AutoMapper();
var map = mapper.GetMap(typeof(SomeClass));
var properties = map.Properties;
var keyProperties = properties.Where(p => p.IsKey);
var creator = new SchemaManager(new SqlConnectionFactory(ConnectionString), "testtable", "testdata", "testproc", keyProperties, properties, schema: "bimse");
creator.DropSchema(true, true, true);
creator.CreateSchema(true, true, true);
}
public void CanCreateSchema()
{
using var connection = new SqlConnection(ConnectionString);
connection.Open();
using var command = connection.CreateCommand();
command.CommandText = @"
if not exists (select top 1 * from [sys].[schemas] where [name] = 'bimse')
exec('create schema bimse');
";
command.ExecuteNonQuery();
var mapper = new AutoMapper();
var map = mapper.GetMap(typeof(SomeClass));
var properties = map.Properties;
var keyProperties = properties.Where(p => p.IsKey);
var creator = new SchemaManager(new SqlConnectionFactory(ConnectionString), "testtable", "testdata", "testproc", keyProperties, properties, schema: "bimse");
creator.DropSchema(true, true, true);
creator.CreateSchema(true, true, true);
}
/// <summary>
/// Immediately executes DROP statements for the things you select by setting <paramref name="dropProcedure"/>,
/// <paramref name="dropType"/>, and/or <paramref name="dropTable"/> to <code>true</code>.
/// </summary>
public void DropSchema(bool dropProcedure = false, bool dropType = false, bool dropTable = false)
{
_schemaManager.DropSchema(dropProcedure, dropType, dropTable);
}
