Getting distinct values from an ArrayList in C#

Question

I have an ArrayList that looks like this

This is how clientArray was formed:

ArrayList clientArray = new ArrayList();

foreach (Dictionary<string, object> media in mediaList)
{
    // get the Advertisers container object
    Dictionary<string, object> clientContainer = (Dictionary<string, object>)media["Advertisers"];

    //get the list of Advertisers (clients)
    var clientList = clientContainer["Advertiser"] as ArrayList;
    var clientListList = clientList.Cast<Dictionary<string, object>>().ToList();

    //add fields not olalready in the dictionary
    clientListList.ForEach(d => d.Add("MediaCode", media["Code"].ToString()));
    clientListList.ForEach(d => d.Add("MediaName", media["Name"].ToString()));
    clientListList.ForEach(d => d.Add("AgencyAlpha", mediaResponse["AgencyAlpha"].ToString()));
    clientListList.ForEach(d => d.Add("CreatedBy", System.Reflection.Assembly.GetExecutingAssembly().FullName.ToString()));
    clientListList.ForEach(d => d.Add("CreatedDt", DateTime.Now));

    foreach (Dictionary<string, object> client in clientListList)
    {
        clientArray.Add(client);
    }
}

This is how clientArray looks like:

{
  "client": [
    {
      "Code": "ABC",
      "Name": "ABC Inc",
      "BusinessKey": "ABC123",
      "MediaCode": "I",
      "MediaName": "Interactive",
      "AgencyAlpha": "UB",
      "CreatedBy": "DataApi, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null",
      "CreatedDt": "2014-04-08T12:47:54.5855957-04:00"
    },
    {
      "Code": "DEF",
      "Name": "DEF Inc",
      "BusinessKey": "DEF456",
      "MediaCode": "I",
      "MediaName": "Interactive",
      "AgencyAlpha": "UB",
      "CreatedBy": "DataApi, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null",
      "CreatedDt": "2014-04-08T12:47:54.5855957-04:00"
    },
etc...

I need to put all DISTINCT Codes into a list. What I have so far is returning all Codes (not what I want). How do I do this?

List<string> listOfCodes = new List<string>();

foreach (Dictionary<string, object> obj in clientArray as IEnumerable)
{
    listOfCodes.Insert(0, obj["Code"].ToString());
}

listOfCodes.Distinct().ToList();

I don't see any array list in your code. I see a List<T> the other thing posted above it is a json blob. Try to state your question more accurately or you probably will not get a good answer. — evanmcdonnal
– evanmcdonnal, Commented Apr 9, 2014 at 16:54

Nicholas Carey · Accepted Answer · 2014-04-09 17:04:01Z

2

Something like this ought to do you:

ArrayList = GetMyArrayList() ;

...

List<string> ListOfCodes = clientArray
.Cast<Dictionary<string,object>>()
.Select( x => x["Code"] as string)
.Distinct( StringComparer.OrdinalIgnoreCase )
.ToList()
;

Another approach would be to use HashSet<T> or SortedSet<T>, something like:

IEnumerable<string> codeBag = clientArray
                              .Cast<Dictionary<string,object>>()
                              .Select( x => x["Code"] as string)
                              .Where( s => !string.IsNullOrEmpty(s) )
                              ;
HashSet<string>     codeSet = new HashSet<string>( codeBag , StringComparer.OrdinalIgnoreCase ) ;

edited Apr 9, 2014 at 17:04

answered Apr 9, 2014 at 16:58

Nicholas Carey

75.1k16 gold badges96 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting distinct values from an ArrayList in C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related