public static bool CanConnect(SqlDBHandle sqlDb) { bool canConnect = false; string dbName = sqlDb.DBName; sqlDb.DBName = "master"; SqlConnection sqlConnection = new SqlConnection(sqlDb.ConnectionString); try { sqlConnection.Open(); canConnect = true; sqlConnection.Close(); } catch { } if (!canConnect) { return(false); } sqlDb.DBName = dbName; if (!SqlDbExists(sqlDb)) { return(true); } canConnect = false; sqlConnection = new SqlConnection(sqlDb.ConnectionString); try { sqlConnection.Open(); canConnect = true; sqlConnection.Close(); } catch { } return(canConnect); }
public static void DeleteSqlDb(SqlDBHandle sqlDb) { string dbName = sqlDb.DBName; sqlDb.DBName = null; var sqlConnection = new MySqlConnection(sqlDb.ConnectionString); sqlConnection.Open(); new MySqlCommand("DROP DATABASE " + dbName, sqlConnection).ExecuteNonQuery(); }
public static bool SqlDbExists(SqlDBHandle sqlDb) { string commandText = "select * from master.dbo.sysdatabases where name=\'" + sqlDb.DBName + "\'"; sqlDb.DBName = "videorent"; bool ret = true; using (var sqlConnection = new MySqlConnection(sqlDb.ConnectionString)) try { sqlConnection.Open(); //using (var sqlCommand = new MySqlCommand(commandText, sqlConnection)) //{ // var reader = sqlCommand.ExecuteReader(); // ret = reader.HasRows; // reader.Close(); //} sqlConnection.Close(); } catch (MySqlException) { ret = false; } return(ret); }