Scenario I am playing MVC NerdDinner project and using ado.net entity data model instead on 'dbml'
I have 2 database tables Dinner & RSVP where RSVP contains DinnerID as foreign key from Dinner table.
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
Data
DinnerTable
ID :1
Title : '.Net Architecture'
RSVPTable
ID :1
Dinner ID: 1
AttendeeName : 'Miral'
ID :2
Dinner ID: 1
AttendeeName : 'Shivani'
So when fetching Dinner data which should return its child RSVP data, I am getting RSVP property with 0 records.