Cross edmx "join" between Linq to Entities and Entity Framework

entity-framework linq-to-entities

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.

1
5
12/18/2008 11:06:10 AM

Accepted Answer

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.

4
12/18/2008 1:48:36 PM

Popular Answer

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



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