Does anyone know the linq for selecting all the product variants within a category?
I can select them by iterating each product and then finding the pv for each but was hoping to simplify my code with a simply linq query using joins.
Darren
var query = from pv in _productVariantRepository.Table
join pc in _productCategoryRepository.Table on pv.ProductId equals pc.ProductId
where pc.CategoryId == categoryId
select pv;