I have an object public class Customer public int ID get set public string Name get set public int GroupID get set I return a list that may look like the following List lt Customer gt CustomerList new List lt Customer gt CustomerList Add new Customer ID 1 Name One GroupID 1 CustomerList Add new Customer ID 2 Name Two GroupID 1 CustomerList Add new Customer ID 3 Name Three GroupID 2 CustomerList Add new Customer ID 4 Name Four GroupID 1 CustomerList Add new Customer ID 5 Name Five GroupID 3 CustomerList Add new Customer ID 6 Name Six GroupID 3 I want to return a linq query which will look like CustomerList GroupID 1 UserID 1 UserName UserOne GroupID 1 UserID 2 UserName UserTwo GroupID 1 UserID 4 UserName UserFour GroupID 1 GroupID 2 UserID 3 UserName UserThree GroupID 2 GroupID 3 UserID 5 UserName UserFive GroupID 3 UserID 6 UserName UserSix I tried from Using Linq to group a list of objects into a new grouped list of list of objects code var groupedCustomerList CustomerList GroupBy u gt u GroupID Select grp gt grp ToList ToList works but does not give the desired output

var groupedCustomerList CustomerList GroupBy u gt u GroupID Select grp gt new GroupID grp Key CustomerList grp ToList ToList

Using LINQ to group a list of objects

The Solution to Using LINQ to group a list of objects is

var groupedCustomerList = CustomerList.GroupBy(u => u.GroupID)
                                      .Select(grp =>new { GroupID =grp.Key, CustomerList = grp.ToList()})
                                      .ToList();

~ Answered on 2013-09-02 02:48:59

Using LINQ to group a list of objects

The Solution to Using LINQ to group a list of objects is

Most Viewed Questions: