tblClientProjectProducts |_mmlClientProjectProductsParts |_tblClientProjectPartsI'm trying to create a query that returns a list of ClientProjectProductModel objects. This ClientProjectProductModel model
List<ClientProjectProductModel> retVal = (from products in context.tblClientProjectProducts join mml in context.mmlClientProjectProductsParts on products.ProductId equals mml.ProductId join parts in context.tblClientProjectParts on mml.PartId equals parts.PartId where products.ClientProjectId == ClientProjectId select new ClientProjectProductModel { ProductId = products.ProductId, ProductNumber = products.ProductNumber, ProductSeries = products.ProductSeries, Parts = <=== What goes here? }).ToList();I'm unsure as to how to add in the parts. Can someone show me how to do this>