Using Linq to bind dependent SQL rows

Asked Jun 15 '18 at 15:19

Active Jun 15 '18 at 15:19

Viewed 26 times

I'm trying to find an efficient way to select all dependencies. The idea behind this table is:

Each taskID is a task that will be display to the user.
When taskid 22180 is selected by the user and completed it will automatically enable the other tasks (activateTaskId = 22180) to become available to the user hence inactive = 0. Up to that point everything is fine.
What i need help at is when you have subsequent tasks.

So when taskid (22180) is selected and completed by the user the following tasks become available (22181,22182,22185 and 22186). As you can see if the user selects 22182 then the task dependent on it is 22183 and subsequently 22184 will .

how would i efficiently select all the task that branch off the initial one (22182) no matter how many may exist ?

Thank you

asked Jun 15 '18 at 15:19

Goku1989

Best solution is recursive. – senthilkumar2185 Jun 15 '18 at 15:29
example for recursive https://stackoverflow.com/questions/20974248/recursive-hierarchy-recursive-query-using-linq https://stackoverflow.com/questions/21262391/recursive-linq-query-select-item-and-all-children-with-subchildren/21262626 – senthilkumar2185 Jun 15 '18 at 15:29
1

Could you edit your question to put in missing text and not use an image? – NetMage Jun 15 '18 at 17:44

Using Linq to bind dependent SQL rows

0 Answers0