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.

Correct syntax var dinner =_nerdDinnerEntities.Dinner.Include("RSVP").Where(dd => dd.ID == ID).FirstOrDefault(); Your require to write Include before First i.e. 'Include' is a method on Entity over here 'Dinner'. Also it includes child table name i.e. 'RSVP' and the property 'AttendeeName'. I tried passing just the one of the property 'AttendeeName' but it didnt worked.
–
MiralJun 10 '09 at 11:45