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?
Technorati Tags:
LINQ to SQL