Query multiple connections
Forgive me if this has already been asked.... my search did not show up any results.
I was wondering if it's possible to use another connection's DataContext in a query? Please note, I'm not asking to use a linked DB or another one local to the database server. These would be two completely separate databases on different database servers with no database link. I'd like to be able to use C# Statements to query one database, then loop through those results, querying another database on each result. I can do it by making one a SQL connection and using String SQL statements, but obviously I'd rather do both as LINQ statements. Is this possible, and if so, how do I do it?
I was wondering if it's possible to use another connection's DataContext in a query? Please note, I'm not asking to use a linked DB or another one local to the database server. These would be two completely separate databases on different database servers with no database link. I'd like to be able to use C# Statements to query one database, then loop through those results, querying another database on each result. I can do it by making one a SQL connection and using String SQL statements, but obviously I'd rather do both as LINQ statements. Is this possible, and if so, how do I do it?
Comments
http://forum.linqpad.net/discussion/comment/1982/#Comment_1982
Not an optimal solution but it is possible.
Please vote for the linked suggestion on uservoice.