Hello all - here is another Linq TO SQL Join question - I am ok with single joins and have used join into group but this one has multiple joins and right outers and I be stumped ... any help would be greatly appreciated
Table structure:
category has many sections
section has zero or many items
items has zero or many attribs
T-SQL abbreviated but works as expected :
SELECT category.ID, category.Name, section.ID, section.Title, item.ID, item.Name, attrib.ID, attrib.Name,
FROM item LEFT OUTER JOIN attrib ON item.ID = attrib.ItemID RIGHT OUTER JOIN section ON item.SectionID = section.ID RIGHT OUTER JOIN category ON section.CategoryID = category.ID
WHERE (category.ID = 319)
can anyone help with this? C# is preferable.
thanks v much !!!