provide the ability to query multiple schemas with the IQ driver for oracle.
An Oracle user may have access to multiple schemas with table definitions. It would be nice to specify the schema in the query.
E.G. I have a user that can see two schemas ,users and customers. Currently I have to specify the schema I want to use when setting up the connection. So, I can only query one schema per session. It would be great if I could do something like the following:
var customers = from c in customers.sometable
select c;
var users = from u in users.sometable
select u;
...
in a single session
Anonymous
shared this idea
-
Lyle Hart
commented
Has there been any progress with this?
-
Ivan Garcia
commented
Is LinqPad completely unable to do this? Any known workarounds?
-
Anonymous
commented
Also, would be good if you could join two tables from different servers like this:
var x = from c in server1.users.sometable
join d in server2.dept.sometable
on c.userid equals d.userid
select new { c, d }