Support for multiple databases (EF/L2S) on different servers
I would like to be able to query multiple databases, that are on different servers. Possible use would be "server.database.table" or something like that.
Marcelino Jorge Romero commented
To the author of LINQPad i have to say that it disappoints me the fact that this great product lacks a very important functionality. I recently purchase a premium license to work with the company's databases that are on different servers and very sadly LINQPad doesn't offer me this functionality. I have to comment that the company i work for has different servers (and they are not all of them linked) with different users and permissions. Apart of the unlinked servers the window "Additional Databases" throws me error when i try to "Pick from list...", "Databases to include from other (linked) servers" even if a server is linked. I don't know why is this happening but databases are not mine to be able to change them...
I could provide a screenshot if requested.
I hope that my voice will be heard and this function will be implemented for all the people who need to work with different servers...
Peter Crabtree commented
A first step here would be simply allowing independent LINQ statements from different servers, allowing users to do .AsEnumerable() and the joins themselves.
Better, of course, would be allowing joins by transforming the LINQ, but that gets complicated quickly.
Would be really nice, especially when there is no DB link between two databases....