Querying a link table (ish)

[sitefinitysteve]

I have a Product table, Category table, and a Linktable with a sortIndex column.

How do I write a query to say

Show me all products in X Category, where the Categorys ParentID column is Y

I cant seem to figureout where to go on this one :)

[Zoran]

Hello Steve,

 I am not sure if I got your idea right tis time, but here is my best guess for what you had in mind with your lat letter:

var products = (from c in context.Categories
           where c.ParentID = 'Y').SelectMany(c => c.Products);

All the best,
Zoran
the Telerik team