Home

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?

Comments

Sign In or Register to comment.