Edit Question - KnowledgeHub

Title Body

I've got a list of objects with the following properties: int TownId, int CompanyId, int ProductId, int[] Prices I want to turn this into a list of TownCompany objects; each item having the following properties: int TownId, int CompanyId, int[] Products, int[] Prices So I can do flatList.GroupBy(l => new { l.TownId, l.CompanyId }) To get a list of groups, which has all the products and prices for each town/company pair. Now, for each key in this lookup, I want to flatten/merge all the values. Seems like I should be able to use SelectMany , but I always get a bit confused by what projections to supply to it... How do I turn this list of groups into a list of flattened lists for each key? I hope I've made sense. Example: If my original list is this: new[] { new Item { TownId = 1, CompanyId = 10, ProductId = 100, Prices = new [] { 1, 2 } }, new Item { TownId = 1, CompanyId = 10, ProductId = 101, Prices = new [] { 3 } }, }; I want a list that looks like this: { { TownId: 1, CompanyId: 10, Products: [100, 101], Prices: [1, 2, 3] } }

Tags (comma-separated) Cancel