I have a collection of huge records (6000+) wherein the object in the collections has got 50+ properties, so ideally it is not a good idea to run a "For-Each" loop here.
What I want is a "GroupBy" clause which would get me a Dictionary (Of String, String) from this collection where the key is the primary key (A) of this object and the value would be concatenation of another property (B) with "|" seperated values for each key (A).
Dim collectionA As A() = DAL.searchForComments
Here, "A" has got 50 properties (ID, Name, Address etc.) and "collectionA" has got multiple entries for "ID". What I want is to build a Dictionary (Of ID, Name) where all the "Name" values would be "|" seperated for each ID.
Any help would be appreciated.
Thanks very much.