Using Include in Entity Framework 4 with lambda expressions

c# entity-framework-4 lambda
Dani picture Dani · Dec 28, 2010 · Viewed 77.7k times · Source

I've seen many articles about how to overcome this matter, all related to CTP4, Or adding my own extension methods.

Is there an "official" EF4 included way to use lambda expressions inside include (for both first level relations and also 2nd and more level) or is it eventually was not included in the RTM ?

It there is one - I would be glad to learn how to do it, as using lambda expression in my code now (with #system.data.entity #system.data.linq) still gives me:

Cannot convert lambda expression to type 'string' because it is not a delegate type on: 

var customers = from c in
context.Customers.Include(c=>c.Phone)

Answer

cecilphillip picture cecilphillip · Apr 19, 2011

The RTM version of Entity Framework 4.1 actually includes extension methods in the EntityFramework.dll file, for eager loading with lambda through the Include function. Just include the DLL in your project and you should be able to write code like:

var princesses1 = context.Princesses.Include(p => p.Unicorns).ToList();

Remember to add an Import/Using statement to include the System.Data.Entity namespace. Otherwise the compiler cannot find the extension methods. E.g:

using System.Data.Entity;

See this ADO.NET team blog article for more information.

Related questions

Expression cannot contain lambda expressions

I have fetched the List<> object as below (with .Include()): List<vDetail> entityvDetails = context.vDetails .Include("payInstallment.appsDetail") .Include("payInstallment.appsDetail.application") .Include("payInstallment.appsDetail.purposes") .Where(e => e.vch_id == 123).ToList(); And then somewhere …

Read More
Validation failed for one or more entities. See 'EntityValidationErrors' property for more details

I am having this error when seeding my database with code first approach. Validation failed for one or more entities. See 'EntityValidationErrors' property for more details. To be honest I don't know how to check the content of the validation …

Read More
There is already an open DataReader associated with this Command which must be closed first

I have this query and I get the error in this function: var accounts = from account in context.Accounts from guranteer in account.Gurantors select new AccountsReport { CreditRegistryId = account.CreditRegistryId, AccountNumber = account.AccountNo, DateOpened = account.DateOpened, }; return accounts.AsEnumerable() .Select((…

Read More