How is this Nested Set SQL query converted into a LINQ query?
- by Chad
Querying a Nested Set Model table, here's the SQL... how can this be written in LINQ?
SELECT parent.name
FROM nested_category AS node, nested_category AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.name = 'FLASH'
ORDER BY parent.lft;
particularly, the FROM part... never tried to do anything like that in LINQ.