How to load data from tables with foreign keys in entity framework

asp.net dynamic-data entity-framework linq-to-entities

Question

I developed and entity framework (.edmx) application in 4.0 in that i got all the data of my querying table and its foreign key referenced tables data also. but when i change my project to 3.5 i am unable to get the data of foreign key referenced tables data. Please help me out...

1
2
5/3/2010 5:46:44 AM

Accepted Answer

In EF4 lazy loading is included and is on by default.

No such luck in prior versions: You may need to add an .Include() to fetch the other data automatically (eager loading) or call Load() on the references to load them (manually).

If the reference table was say "Details" you would do ...

var featuredOffers = context.Hosters_FeaturedOffer.Include("Details").ToList();

See http://msdn.microsoft.com/en-us/library/bb896272.aspx

BTW: Do a search for "strongly typed Include" too - there are some extension methods people have written to remove the magic string and replace it with a compile time checked lambda expression.

5
2/25/2014 11:13:23 AM

Popular Answer

For the future answers if you are using newer version of EF;

 var o = db.Order.Include(i => i.User).Include(i => i.OrderItem).FirstOrDefault(x=>x.OrderId == orderId);


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow