public override void Create()
{
using (var masterConnection = _connection.CreateMasterConnection())
{
_statementExecutor.ExecuteNonQuery(masterConnection, CreateCreateOperations());
ClearPool();
}
}
public override void Create()
{
Console.WriteLine("CREATE " +);
using (var masterConnection = _connection.CreateMasterConnection())
{
_statementExecutor.ExecuteNonQuery(masterConnection, null, CreateCreateOperations());
ClearPool();
}
}
public override void Create()
{
using (var masterConnection = _connection.CreateMasterConnection())
{
_statementExecutor.ExecuteNonQuery(masterConnection, null, CreateCreateOperations());
ClearPool();
}
Exists(retryOnNotExists: true);
}
public override void Delete()
{
ClearAllPools();
using (var masterConnection = _connection.CreateMasterConnection())
{
SqlStatementExecutor
.ExecuteNonQuery(masterConnection, CreateDropCommands());
}
}
public override void CreateTables(IModel model)
{
Check.NotNull(model, "model");
var operations = _modelDiffer.DiffSource(model);
var statements = _generator.Generate(operations, generateIdempotentSql: false);
// TODO: Delete database on error
using (var connection = _connection.CreateConnectionReadWrite())
{
_executor.ExecuteNonQuery(connection, statements);
}
}
public override void CreateTables(IModel model)
{
Check.NotNull(model, "model");
var generator = _generatorFactory.Create();
var operations = _modelDiffer.CreateSchema(model);
var statements = generator.Generate(operations);
// TODO: Delete database on error
using (var connection = _connection.CreateConnectionReadWrite())
{
_executor.ExecuteNonQuery(connection, null, statements);
}
}
protected virtual void Execute([NotNull] IEnumerable <SqlBatch> sqlBatches, bool ensureDatabase = false)
{
Check.NotNull(sqlBatches, nameof(sqlBatches));
if (ensureDatabase && !_dataStoreCreator.Exists())
{
_dataStoreCreator.Create();
}
using (var transaction = _connection.BeginTransaction())
{
_executor.ExecuteNonQuery(_connection, transaction.DbTransaction, sqlBatches);
transaction.Commit();
}
}
public override void CreateTables(IModel model)
{
Check.NotNull(model, "model");
// TODO: SQLiteMigrationOperationSqlGenerator should get this from DI
_generator.Database = _modelDiffer.DatabaseBuilder.GetDatabase(model);
var operations = _modelDiffer.CreateSchema(model);
var statements = _generator.Generate(operations);
// TODO: Delete database on error
using (var connection = _connection.CreateConnectionReadWrite())
{
_executor.ExecuteNonQuery(connection, null, statements);
}
}
private static void CreateDatabaseSequence(BronieContext context, DataStoreConnection storeConnection)
{
var executor = new SqlStatementExecutor();
var operations = new SqlServerSequenceValueGeneratorFactory(executor)
.GetUpMigrationOperations(context.Model.GetEntityType(typeof(Pegasus))
.GetProperty("Identifier"));
var sql = new SqlServerMigrationOperationSqlGenerator(new SqlServerTypeMapper())
.Generate(operations, generateIdempotentSql: false);
// TODO: Should be able to get relational connection without cast
var connection = ((RelationalConnection)storeConnection).DbConnection;
executor.ExecuteNonQuery(connection, sql);
}
