private void DropDatabase()
{
var sb = new SqlConnectionStringBuilder(_settings.ConnectionString);
var dbName = sb.InitialCatalog;
sb.InitialCatalog = "master";
using var dbConnection = new SqlConnection(sb.ConnectionString);
dbConnection.Open();
var command = dbConnection.CreateCommand();
command.CommandText = SqlScripts.DropDb(dbName);
command.ExecuteNonQuery();
}
private static void CreateDatabase()
{
var sb = new SqlConnectionStringBuilder(TestDbConnectionString);
var dbName = sb.InitialCatalog;
sb.InitialCatalog = "master";
using (IDbConnection dbConnection = new SqlConnection(sb.ConnectionString))
{
dbConnection.Open();
var command = dbConnection.CreateCommand();
command.CommandText = SqlScripts.CreateDb(dbName);
command.ExecuteNonQuery();
}
}