Foreign Key Relationship

[ziegler]

Is there a way to link 2 table so one of the table_1 C# code can have a getter to get the associated records in table_2.

  
Table_1

            ID

            getTable_2()

 
Table_2

            Table1ID (maps to Table_1.ID)

            getTable_1()

  
So in this case Table_1 would have a getter to get rows from Table_2 and Table_2 have a getter to get rows from Table_1?  Also I am using Abator.