Hi, I've just started using linq and was wondering if anyone could point me in the right direction for a few things. ok so I have a product catalogue and I want a linq query to filter products based on a few criteria. firstly my product categories are in a heirarchy so I want to select all the products from my current category plus all the products from all the categories which are decendants of the current category. [Currently doing this using CTE's in a stored procedure (selectchildcategoriesbycategoryid)]
Read More...