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?