I did not see a resolution to this post so I thought I would ask this again using a tutorial as an example. I looked into this in EF4 and due to the limits I gave up. Now with EF6 I'm wondering if you can reference multiple databases or not.
For example, if you look at the Contonso University tutorial from Tom D you see a simple app using a single DB. What if all the people related data was contained in a separate DB. This would be the models like Person, Student, and Instructor which use the Person physical table. Can that be moved to a separate DB and have all the other functionality work without something like synonyms?
In a real world example we have separate databases for employee data and project data. We have an application for employee related information which can use just the employee DB with no problem. But you cannot build a project app without referencing the employee DB (to track who is working on what project). Ideally I want to build the employee app with EF and then turn around and leverage all that work with the project app. Then move on to a billing app which has another separate DB but would refer to both employee and project DBs.
I think the answer is "no" and this still can't be done but I want to get clarification.
