public DataRow ExecuteQueryRow(string CommandText)
        {
            DataRow row;

            try
            {
                DataTable table = this.ExecuteQueryTable(CommandText);
                row = (table.Rows.Count > 0) ? table.Rows[0] : null;
            }
            catch (Exception)
            {
                Output.WriteLine("(Sql) An exception has been throw while a query executon.\nDisposing MySql client #" + this.int_0 + "  and retrying the QueryRowExecution.", OutputLevel.Notification);
                SqlDatabaseManager.dictionary_0.Remove(this.int_0);
                this.Close();
                using (SqlDatabaseClient client = SqlDatabaseManager.GetClient())
                {
                    row = client.ExecuteQueryRow(CommandText);
                }
            }
            return(row);
        }
        public DataTable ExecuteQueryTable(string CommandText)
        {
            DataTable table;

            try
            {
                DataSet set = this.ExecuteQuerySet(CommandText);
                table = (set.Tables.Count > 0) ? set.Tables[0] : null;
            }
            catch (Exception exception)
            {
                Console.WriteLine("Exception: " + exception);
                Output.WriteLine("(Sql) An exception has been throw while a query executon.\nDisposing MySql client #" + this.int_0 + "  and retrying the QueryTableExecution.", OutputLevel.Notification);
                SqlDatabaseManager.dictionary_0.Remove(this.int_0);
                this.Close();
                using (SqlDatabaseClient client = SqlDatabaseManager.GetClient())
                {
                    table = client.ExecuteQueryTable(CommandText);
                }
            }
            return(table);
        }
        public object ExecuteScalar(string CommandText)
        {
            object obj3;

            try
            {
                this.mySqlCommand_0.CommandText = CommandText;
                object obj2 = this.mySqlCommand_0.ExecuteScalar();
                this.ResetCommand();
                obj3 = obj2;
            }
            catch (Exception)
            {
                Output.WriteLine("(Sql) An exception has been throw while a query executon.\nDisposing MySql client #" + this.int_0 + "  and retrying the QueryScalarExecution.", OutputLevel.Notification);
                SqlDatabaseManager.dictionary_0.Remove(this.int_0);
                this.Close();
                using (SqlDatabaseClient client = SqlDatabaseManager.GetClient())
                {
                    obj3 = client.ExecuteScalar(CommandText);
                }
            }
            return(obj3);
        }
        public int ExecuteNonQuery(string CommandText)
        {
            int num2;

            try
            {
                this.mySqlCommand_0.CommandText = CommandText;
                int num = this.mySqlCommand_0.ExecuteNonQuery();
                this.ResetCommand();
                num2 = num;
            }
            catch (Exception exception)
            {
                Console.WriteLine("Exception: " + exception);
                Output.WriteLine("(Sql) An exception has been throw while a query executon.\nDisposing MySql client #" + this.int_0 + "  and retrying the NonQueryExecution.", OutputLevel.Notification);
                SqlDatabaseManager.dictionary_0.Remove(this.int_0);
                this.Close();
                using (SqlDatabaseClient client = SqlDatabaseManager.GetClient())
                {
                    num2 = client.ExecuteNonQuery(CommandText);
                }
            }
            return(num2);
        }