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); } }