>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?

Interesting. I don't think it actually supports that just yet, but I remember hearing something that it was on their list (some podcast I just listened to, I think).

You could just write a recursive query using CTE to do this instead. Let me know if you need a sample - it's pretty cool.