Should be a very easy question that will take a minute to answer. Finally got around to using some cool .NET 3.5 features! I am trying to figure out how to write a LINQ query to give me a list of all x's parents recursively.
My table structure is: id, parent_id, name var tree = from parent in table where table.parent_id == parent.id select parent.name; The query above gives me a list of x's parents. I need all of x's grandparents, great grandparents, etc... Thanks,
