Can I convert SQL to Linq with Linqpad? or natively recurse
I've got 2 humdinger SQL stored procs that spit out a hierarchcical tree of categories - by field called Parent. They work by stuffing each level into a TempTable as they traverse - one goes up (showing parents of parents - ideal for breadcrumbs list) another down (tree branches - ideal for filling treeviews)
Q1 I see my linq as SQL - can I go the other way around?
if not
Q2 can I recurse in Linq?
Comments
- 
            LINQPad cannot convert SQL to LINQ. There is a product called Linqer that does this: 
 https://www.sqltolinq.com/

