c# 4.0 - EF Code First - Include(x => x.Properties.Entity) a 1 : Many association

Question

Given a EF-Code First CTP5 entity layout like:

public class Person { ... }

which has a collection of:

public class Address { ... }

which has a single association of:

public class Mailbox { ... }

I want to do:

PersonQuery.Include(x => x.Addresses).Include("Addresses.Mailbox")

WITHOUT using a magic string. I want to do it using a lambda expression.

I am aware what I typed above will compile and will bring back all Persons matching the search criteria with their addresses and each addresses' mailbox eager loaded, but it's in a string which irritates me.

How do I do it without a string?

Thanks Stack!

question from:https://stackoverflow.com/questions/5159621/ef-code-first-includex-x-properties-entity-a-1-many-association

Answer 1

For that you can use the Select method:

PersonQuery.Include(x => x.Addresses.Select(a => a.Mailbox));

You can find other examples in here and here.