internal static void CreateDatabase(ICakeContext context, String connectionString, String databaseName, CreateDatabaseSettings settings)
{
settings.AssignNames(databaseName);
var sql = GenerateCreateDbSql(databaseName, settings);
using (var connection = OpenSqlConnection(context, connectionString))
{
context.Log.Debug($"Executing SQL : {sql}");
var command = CreateSqlCommand(sql, connection);
command.ExecuteNonQuery();
context.Log.Information($"Database {databaseName} is created if it was not there");
}
}
internal static void CreateDatabaseIfNotExists(ICakeContext context, String connectionString, String databaseName, CreateDatabaseSettings settings)
{
settings.AssignNames(databaseName);
var sql = GenerateCreateDbSql(databaseName, settings);
sql = "if (select DB_ID(@DatabaseName)) is null " + sql;
using (var connection = OpenSqlConnection(context, connectionString))
{
context.Log.Debug($"Executing SQL : {sql}");
var command = CreateSqlCommand(sql, connection);
command.Parameters.AddWithValue("@DatabaseName", databaseName);
command.ExecuteNonQuery();
context.Log.Information($"Database {databaseName} is created if it was not there");
}
}
