Sean Lynch

I figured out what I was missing in I think I’m missing something. It was using “.Join” instead of “.Where”.

And it turns out that it is a much cleaner implementation then I had done in Got my nice Urls working. So here it is.

var cats = this.Categories.Where(c => c.Name == navList.First().Value);
foreach (var item in navList.Skip(1))
{
    string name = item.Value;
    cats = cats.Join(this.Categories.Where(c => c.Name == name)
        ,c=>c.Key,c=>c.ParentKey.Value,(c,p)=>p);
}
cat = cats.First();

Which generates the correct Sql bellow

Edit:
Does anyone know if there is a book for LINQ (to SQL in particular) that would be equivilent to Essential Windows Workflow Foundation, that explains how they ended up with the solution they did?