How is this Nested Set SQL query converted into a LINQ query?
Posted
by Chad
on Stack Overflow
See other posts from Stack Overflow
or by Chad
Published on 2010-03-23T04:16:09Z
Indexed on
2010/03/23
4:21 UTC
Read the original article
Hit count: 320
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.
© Stack Overflow or respective owner