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?
Q2 can I recurse in Linq?