public virtual bool Exists()
{
var exists = false;
if (!_creator.Exists())
{
return(exists);
}
var command = (SqlCommand)_connection.DbConnection.CreateCommand();
command.CommandText =
@"SELECT 1 FROM [INFORMATION_SCHEMA].[TABLES]
WHERE [TABLE_SCHEMA] = N'dbo' AND [TABLE_NAME] = '" + MigrationHistoryTableName + "' AND [TABLE_TYPE] = 'BASE TABLE'";
_connection.Open();
try
{
exists = command.ExecuteScalar() != null;
}
finally
{
_connection.Close();
}
return(exists);
}
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();
}
}