How to iterate through result where one field is collection

Question

Hi I'm tranforming a SQL query to linq or Lambda then I get this result where one property is a collection of objects. So basically I only have 2 properties in my object. First property is the purchase ID the second property is a collection of employee ID . The result in LINQ is an anonymous type having fields PurchaseID and a collection of EmployeeID. My problem is assigning the value and returning it as a list of EmployeePurchases object. class EmployeePurchases { PurchaseID int {get; set;} EmployeeID int {get;set;} } My attempt on this is questionable since running the SQL query and comparing the result vs. the result of this code below does not match. Sorry I'm very new to Linq/Lambda. ...result variable is the output of Entity Framework selection from DB var results = (from q in result where q.EmployeeID.Any() select new {StaffCollection = q.EmployeeID PurchaseID = q.PurchaseID }).ToList(); var col = new List (); foreach (var i in results) { var x = new EmployeePurchases(); var seq = i.StaffCollection.GetEnumerator(); x.PurchaseID = i.PurchaseID; while (seq.MoveNext()) { x.EmployeeID = seq.Current.EmployeeID; col.Add(x); } } return col; Thanks in advance.

Lawrence Pond · Answer

Please look at the linq .SelectMany() option I also just posted an sample code a few minutes ago the posting title in Linq is  C# LINQ if you take the code I wrote It has and add the following statement it has a value field then a collection if you add the following line it will flatten out the collection to the sample I provided to flatten out is why SelectMany exists code is here myItemsGroupedByFruit.SelectMany(p=> p.Category);

Lawrence Pond · Answer

void Main() { // add some data var epList = new[] { new EmployeePurchases { PurchaseID=1 EmployeeID=2} new EmployeePurchases { PurchaseID=1 EmployeeID=3} new EmployeePurchases { PurchaseID=1 EmployeeID=4} new EmployeePurchases { PurchaseID=1 EmployeeID=5} new EmployeePurchases { PurchaseID=1 EmployeeID=6} new EmployeePurchases { PurchaseID=1 EmployeeID=7} }; //Notice how to cast the list as list List mlist = epList.Select (l => new EmployeePurchases{EmployeeID=l.EmployeeIDPurchaseID= l.PurchaseID }).ToList(); // mlist is a strongly type List of employeePurchases } public class EmployeePurchases { public int PurchaseID {get; set;} public int EmployeeID {get;set;} }

Janie Lane · Answer

Solved finally. Below is my solution using 2 ForEach. If you have another approach to this kindly post I'm in the learning process and would like to know your approach. Thanks for reading. var col = new List (); results.ForEach(i => { i.StaffCollection.ForEach(a => { var x = new EmployeePurchases(); x.EmployeeID = a.EmployeeID; x.PurchaseID = i.PurchaseID; col.Add(x); }); });