add 2 entity from different DB with EF

Question

Hi,

does anyone know if is possible to add 2 entities into EF model from 2 DB.

If not, what suggestions can you gave me to build a query that affects 2 databases

Answer 1

It is not possible to map a conceptual model, to two storage models.

If you find yourself needing to join between 2 databases, I have seen this accomplished via Data Services. You basically talk via URIs. So you query for URI to some set of data (ultimately gives you the surrogate key) and then you use that to query for data in the second database.

Answer 2

Actually, there is no direct support for this scenario, MSFT members state it in this thread.
However, Rafael Krisller and Akhil Karkera suggest some workarounds here.