TvDatabase.TvBusinessLayer.GetProgramGenres C# (CSharp) Method

    public List<string> GetProgramGenres()
    {
      List<string> genres = new List<string>();
      string connectString = ProviderFactory.GetDefaultProvider().ConnectionString;

      string provider = ProviderFactory.GetDefaultProvider().Name.ToLowerInvariant();
      if (provider == "mysql")
      {
        using (MySqlConnection connect = new MySqlConnection(connectString))
        {
          connect.Open();
          using (MySqlCommand cmd = connect.CreateCommand())
          {
            cmd.CommandText = "select distinct(genre) from Program order by genre";
            cmd.CommandType = CommandType.Text;
            using (IDataReader reader = cmd.ExecuteReader())
            {
              while (reader.Read())
              {
                genres.Add((string)reader[0]);
              }
              reader.Close();
            }
          }
          connect.Close();
        }
      }
      else
      {
        using (OleDbConnection connect = new OleDbConnection("Provider=SQLOLEDB;" + connectString))
        {
          connect.Open();
          using (OleDbCommand cmd = connect.CreateCommand())
          {
            cmd.CommandText = "select distinct(genre) from Program order by genre";
            cmd.CommandType = CommandType.Text;
            using (IDataReader reader = cmd.ExecuteReader())
            {
              while (reader.Read())
              {
                genres.Add((string)reader[0]);
              }
              reader.Close();
            }
          }
          connect.Close();
        }
      }
      return genres;
    }

    public override void LoadSettings()
    {
      base.LoadSettings();
      TvBusinessLayer layer = new TvBusinessLayer();

      // Load the list of all EPG provided program genres.
      _allProgramGenres = (List<string>)layer.GetProgramGenres();

      // Load the list of MP genres.
      _mpGenres = layer.GetMpGenres();

      // Populate the guide genre and program genre lists.
      PopulateGuideGenreList();
      PopulateProgramGenreList();
    }