LINQ Select from the sub-list

Question

How can I make a Linq request to grab ALL trademarks from a category?

public class ProductCategory { public List<Product> categoryProducts; } public class Product { public List<Productprice> productPrices; } public class Productprice { public List<Productpricediscount> priceDiscounts; } 

My query should look something like this:

 categoryProducts.Select(p => p.productPrices).Select(x => x.?!?! 

The problem is that I would expect x. - intellisense offer priceDiscounts , but I get a "list" of values ​​(for example: "Any", "Select", "Miscellaneous", etc.)

Answer 1

You will need to use SelectMany to access priceDiscounts :

 var query = categoryProducts .SelectMany(x => x.productPrices) .SelectMany(y => y.priceDiscounts); 

Answer 2

You need Enumerable.SelectMany

 var result = categoryProducts.SelectMany(x => x.productPrices) .SelectMany(x => x.priceDiscounts);