public bool DatabaseExists() { var dbManager = new DatabaseManager(NHUnitOfWorkFactory._dbProvider, NHUnitOfWorkFactory.connectionString); return dbManager.DatabaseExists(); }
public void DeleteDatabase() { var dbManager = new DatabaseManager(NHUnitOfWorkFactory._dbProvider, NHUnitOfWorkFactory.connectionString); if (dbManager.DatabaseExists()) { dbManager.DropDatabase(); } }
public void CreateDatabase() { var dbManager = new DatabaseManager(NHUnitOfWorkFactory._dbProvider, NHUnitOfWorkFactory.connectionString); if (!dbManager.DatabaseExists()) { dbManager.CreateDatabase(); new SchemaExport(NHUnitOfWorkFactory.builtConfiguration).Create(false, true); if (_dbProvider == DbProvider.MsSqlProvider) { using (var conn = new SqlConnection(NHUnitOfWorkFactory.connectionString)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "RENAME_UNIQUE_KEYS"; cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); } } } } }