public void CreateDatabase()
{
var dbManager = new DatabaseManager(_DbProvider, _connectionString);
// Check if database exists.. (and create it if needed)
if (!dbManager.DatabaseExists())
{
dbManager.CreateDatabase();
new SchemaExport(_builtConfiguration).Create(false, true);
if (_DbProvider == DbProvider.MsSqlProvider)
{
using (var conn = new SqlConnection(_connectionString))
{
try
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "RENAME_UNIQUE_KEYS";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
}
}
finally
{
conn.Close();
}
}
}
}
}
public void DeleteDatabase()
{
var dbManager = new DatabaseManager(_DbProvider, _connectionString);
if (dbManager.DatabaseExists())
dbManager.DropDatabase();
}
public bool DatabaseExists()
{
var dbManager = new DatabaseManager(_DbProvider, _connectionString);
return dbManager.DatabaseExists();
}