title: ado.net entity data model parent child relationship
body: <p>Scenario
  I am playing MVC NerdDinner project and using ado.net entity data model instead on 'dbml'</p>
  
  <p>I have 2 database tables Dinner &amp; RSVP where RSVP contains DinnerID as foreign key from Dinner table.</p>
  
  <p>Now when I am accessing a particular record from Dinner table, it returns a dinner object with RSVP property but there are no data with that property inspite of RSVP table having data with foreign key from Dinner table</p>
  
  <p>Data</p>
  
  <p><b>DinnerTable</b></p>
  
  <p>ID :1<br>
  Title : '.Net Architecture'</p>
  
  <p><b>RSVPTable</b></p>
  
  <p>ID :1<br>
  Dinner ID: 1<br>
  AttendeeName : 'Miral'</p>
  
  <p>ID :2<br>
  Dinner ID: 1<br>
  AttendeeName : 'Shivani'</p>
  
  <p>So when fetching Dinner data which should return its child RSVP data, I am getting RSVP property with 0 records.</p>