LINQ to SQL join tables special blend?

Sounds like a left outer join: (untested) from list in dataContext. Todo_Lists where list. UserID == userID join itemTemp in dataContext.

Todo_List_Items on list. ListID equals item. ListID into itemGroup from item in itemGroup.DefaultIfEmpty() select new { ListID = list.

ListID, ListName = list. ListName, ItemID = item == null? Null : item.

ItemID, ItemName = item == null? Null : item. ItemName } you'll probably need to cast the nulls for the conditional to work - I left it out cos I don't know the type.

See here for more info on left outer joins using linq.

Sounds like a left outer join: (untested) from list in dataContext. Todo_Lists where list. UserID == userID join itemTemp in dataContext.

Todo_List_Items on list. ListID equals item. ListID into itemGroup from item in itemGroup.DefaultIfEmpty() select new { ListID = list.

ListID, ListName = list. ListName, ItemID = item == null? Null : item.

ItemID, ItemName = item == null? Null : item. ItemName }; you'll probably need to cast the nulls for the conditional to work - I left it out cos I don't know the type.

See here for more info on left outer joins using linq.

Thanks a lot! With out your input I wouldn't solve the issue. You can read my write up on how I did it here hackviking.Com/2011/03/linq-to-sql-left-join-with-null-values – Kallsbo Mar 16 at 19:01.

From Lists in dataContext. Todo_Lists where Lists. UserID == userID select new { ListID = Lists.

ListID, ListName = Lists. ListName, Items = dataContext. Todo_List_Items .

Where(i => Lists. ListID == i. ListId) .

Select(new { ItemID = Items. ItemID, ItemName = Items. ItemName } }; That will give you null if there isn't anything in the Items.

Thanks a lot! With out your input I wouldn't solve the issue. You can read my write up on how I did it here hackviking.Com/2011/03/linq-to-sql-left-join-with-null-values – Kallsbo Mar 16 at 19:00.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.