LINQ to SQL
There are 2 entries for the tag
LINQ to SQL
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...
posted @ Tuesday, February 05, 2008 11:02 PM |
I finally found time to work on DevExamples.com again and thought I would check on the suggestion that Richard had left on Got my nice Urls working about using incremental LINQ. Overall I found that I liked the following syntax much better var cats = this.Categories.Where(c => c.Name == navList.First().Value);
foreach (var item in navList.Skip(1))
{
string name = item.Value;
cats = cats.Where(c => c.Name == name);
}
cat = cats.First();
Unfortunately this only works for the first parent in the hierarchy. After the first parent, it continues to simply work off of the single join. The problem...
posted @ Tuesday, February 05, 2008 10:30 PM |