Distinct list from List with Count

Question

Distinct list from List with Count

BigH61 581

I have a List<Object> and object has many fields one of these is LastName. How would i get a list of distinct LastNames and a Count of each time that LastName occured. For Example Jones, Smith, Anderson, Colins, Smith, Jones Would return list Jones, 2 Smith, 2 Anderson, 1 Colins, 1 Update I have managed to achieve the below but in stead of var results I would like a List of Object type Name, Count. Is this possible?

var results = mylist.GroupBy(n=>n.LastName).Select(g=> new{ Name = g.First().LastName, Count = g.Count()}).ToList();

Thank you for your assistance.

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Viorel 126.9K

Try this:

class MyObject
{
   public string Name { get; set; }
   public int Count { get; set; }
}

. . . .

List<MyObject> results = mylist.GroupBy( n => n.LastName ).Select( g => new MyObject { Name = g.Key, Count = g.Count( ) } ).ToList( );

BigH61 581 Reputation points

2023-04-23T11:20:35.9933333+00:00

@Viorel . Thank you so much. I'd tried casting etc but clearly had a blind spot when it came to "new MyObject". Much appreciated.

Share via

Distinct list from List with Count

0 additional answers

Your answer