DisableForeignKey.cs

private void DisableForeignKey(bool flag)
{
    string query = "";
    if (flag)
        query = "SET FOREIGN_KEY_CHECKS=0;";
    else
        query = "SET FOREIGN_KEY_CHECKS=1;";
    try
    {
        using (MySqlConnection connection = new MySqlConnection(_connectionString))
        {
            using (MySqlCommand command = new MySqlCommand())
            {
                connection.Open();
                command.Connection = connection;
                command.CommandText = query;
                command.ExecuteNonQuery();
            }
        }
    }
    catch (Exception ex)
    {
        WriteToConsole("Error: DisableForeignKey()" + "\n" + ex.ToString());
        throw ex;
    }
}