Is it possible to perform joins across different databases using LINQ?
If the databases are on the same server, you can create views (and 3 part naming) so that all the tables are queryable from one database.
If the databases are on different servers, you can use linked servers and views (and 4 part naming) so that all the tables are queryable from one database.