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