private static void DropDatabase() { var recreateDatabaseSql = String.Format( @"DROP DATABASE IF EXISTS `{0}`", ConnectionUtils.GetDatabaseName()); //using (var connection = new OracleConnection( // ConnectionUtils.GetMasterConnectionString())) //{ // connection.Execute(recreateDatabaseSql); //} using (var connection = new OracleConnection(ConnectionUtils.GetMasterConnectionString())) { connection.Execute(@" begin delete from HANGFIRE_STATE; delete from HANGFIRE_SET; delete from HANGFIRE_SERVER; delete from HANGFIRE_LIST; delete from HANGFIRE_JOBSTATE; delete from HANGFIRE_JOBQUEUE; delete from HANGFIRE_JOBPARAMETER; delete from HANGFIRE_JOB; delete from HANGFIRE_HASH; delete from HANGFIRE_DISTRIBUTEDLOCK; delete from HANGFIRE_COUNTER; delete from HANGFIRE_AGGREGATEDCOUNTER; end;"); } }
private static void CreateAndInitializeDatabase() { var recreateDatabaseSql = String.Format( @"CREATE DATABASE IF NOT EXISTS `{0}`", ConnectionUtils.GetDatabaseName()); //using (var connection = new OracleConnection( // ConnectionUtils.GetMasterConnectionString())) //{ // connection.Execute(recreateDatabaseSql); //} using (var connection = new OracleConnection( ConnectionUtils.GetConnectionString())) { OracleObjectsInstaller.Install(connection); } }