I have a table with and ID field and a ParentID field.
For a root record, ParentID = ID
For a child record ParentID = the ID of the Parent record.
All records are in the same table.
This is used for holding loose tree structured data. In VFP I would have just walked the tree manually. I just discovered that SQL server will let me show this as a foreign key relationship, which linq may be able to handle... Any idea if this will work?