entity framework 4 - EF4 cross database relationships

Question

I was wondering if EF4 support cross-databse relationships? For instance:

db1

Author
  Id
  Name

db2

Posts
  Id
  Content
  db1.Author.Id

What ideally I need to do to get this relation in my ef4 model?

Do you guys have any idea?

Thanks

Answer 1

I've found this entry in Microsoft Connect that answers the question about the support given at this moment by EF (actually it is not supported yet).

Also found a thread in Social MSDN about this concern.

Other links on Stack Overflow:

• ADO.Net Entity Framework across multiple databases
• Entity framework 4 and multiple database

In summary, the only given alternatives are:

1. Using views in EF

2. Use NHibernate instead