private static void CreateAndInitializeDatabaseIfNotExists(string schema)
{
var recreateDatabaseSql = String.Format(
@"if db_id('{0}') is null create database [{0}] COLLATE SQL_Latin1_General_CP1_CS_AS",
ConnectionUtils.GetDatabaseName());
using (var conn = ConnectionUtils.GetMasterConnection())
{
conn.Execute(recreateDatabaseSql);
}
using (var conn = ConnectionUtils.GetDatabaseConnection())
{
SqlServerObjectsInstaller.Install(conn, schema);
}
}
private static void RecreateDatabaseAndInstallObjects()
{
var recreateDatabaseSql = String.Format(
@"if db_id('{0}') is null create database [{0}]",
ConnectionUtils.GetDatabaseName());
using (var connection = new SqlConnection(
ConnectionUtils.GetMasterConnectionString()))
{
connection.Execute(recreateDatabaseSql);
}
using (var connection = new SqlConnection(
ConnectionUtils.GetConnectionString()))
{
SqlServerObjectsInstaller.Install(connection);
}
}
