title: Model a database foreign key in c#
body: <p>I am creating a calendar application. I have a Appointment table, and a Person table. The 2 are linked by PersonID field in each table.</p>
  
  <p>My question is, should my underlying .Net Appointment object contain a property for the PersonName, and I populate the object from a database view (or stored procedure that joins the tables) or is it more correct to have the Appointment class contain a People class? If the answer is the latter, what is the best way of populating the Appointment/Person object from the database?</p>