Entity Framework 4, can I have 2 tables from different db servers in the same model?

With Ent开发者_如何学JAVAity Framework 4, can I have 2 tables from different db servers in the same model? I have table X from SQL Server A and Table Y from Server B. Is it possible to have different connection string per table under one model or do I need to have different dbml files?

No you can't. Whole EDMX file have single connection string. Moreover EF don't allow fully qualified names of tables. Defining table TableA a from linked server MyServer.MyDatabase.dbo will probably in SQL query result in something like [MyServer.MyDatabase.dbo].[TableA] and it will throw exception.

If you want support tables from two servers in a single model, try to link your second server to the first server and create a view for each table from the second server in your current database on the first server.

IIRC you might be able to fully qualify the table name in the DBML if they are linked servers. I don't have anything to test on, I know you can do it in Linq2Sql on Different databases on the same server.