tags:

views:

82

answers:

0

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 !!!