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/