private static void SwitchDatabase(string database) { if (SharedDbConnection != null) { // do nothing if database is not changed if (database == SharedDbConnection.Database) { if (SharedDbConnection.State == ConnectionState.Closed) { SharedDbConnection.Open(); } return; } if (SharedDbConnection.State != ConnectionState.Closed) { SharedDbConnection.Close(); SharedDbConnection.Dispose(); } SharedDbConnection.Close(); SharedDbConnection.Dispose(); } SharedDbConnection = new MySqlConnection(ConnectionString(database)); SharedDbConnection.Open(); }
internal static void UseDatabase(string databaseName) { try { if (SharedDbConnection == null) { SwitchDatabase(databaseName); } else { if (SharedDbConnection.State != ConnectionState.Open) { SharedDbConnection.Open(); } } var sqlCommand = new MySqlCommand { CommandType = CommandType.Text, CommandText = string.Format("USE {0}", databaseName), Connection = SharedDbConnection }; sqlCommand.Prepare(); sqlCommand.ExecuteNonQuery(); } catch (MySqlException) { } }
/// <summary> /// Ensure connection is closed /// </summary> private static void CloseConnection() { if (SharedDbConnection.State != ConnectionState.Closed) { SharedDbConnection.Close(); } }
/// <summary> /// Ensure connection is open /// </summary> private static void OpenConnection() { if (SharedDbConnection == null) { SharedDbConnection = new MySqlConnection(ConnectionString(DefaultDatabase())); } if (SharedDbConnection.State != ConnectionState.Open) { SharedDbConnection.Open(); } }
internal static void CloseDatabase() { try { if (SharedDbConnection.State != ConnectionState.Closed) { SharedDbConnection.Close(); } } catch (Exception exception) { Console.WriteLine(exception.Message); } }