change datasource inside in c# statements by syntax

When writing a Query on the top there is a dropdown of connections that are setup. Is it possible to run a query using one connection1 then in code switch connnection1 to connection2 and run a new query?

I am using LINPad Connected to two different Oracle connections created using IQ driver.

the c# code would look something like this

use connection1;
var cnt = table1.Where(t1=>t1.id >200).Count();
use connection2;
var rec = table2.Where(t2=>t2.somecolumn == cnt.column);


Sign In or Register to comment.