Linq to Entities / Entity Framework cross edmx "join"

Question

I have two entities, each from a different database and therefore different edmx files. There is, however, an infered relationship between them.

Foo has many Bars for example.

What's the easiest way to do this join in the EntityFramework, with fewest database calls?

Thanks.

Answer 1

You can do this by adding cross-model navigation properties. This requires manually editing the EDMX. There is an example, including LINQ to Entities, here.

Answer 2

You can do this by using Views to represent data in the other database. Read about cross database joins in EF