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);
}
}
