public static int DropDatabase(string databaseName)
{
OdbcIntegrationTestHelper.CloseAllOdbcConnections();
using (var con = new OdbcConnection(MasterConnectionString))
{
con.Open();
ExecuteNonQuery(string.Format(CultureInfo.InvariantCulture, "SELECT SYSLIB.AbortSessions(1, '{0}', 0, 'Y', 'Y');", User), con);
ExecuteNonQuery("DELETE DATABASE " + '"' + databaseName + '"', con);
return(ExecuteNonQuery("DROP DATABASE " + '"' + databaseName + '"', con));
}
}
public int DropDatabase(string databaseName)
{
OdbcIntegrationTestHelper.CloseAllOdbcConnections();
using (var con = new OdbcConnection(MasterConnectionString))
{
con.Open();
using (var com = new OdbcCommand("DROP USER " + databaseName + " CASCADE", con))
{
try
{
Console.WriteLine("Executing: {0}", com.CommandText);
return(com.ExecuteNonQuery());
}
catch (OdbcException)
{
return(-1);
}
}
}
}