Is there a way (in the connection string or something) that I can set the schema that I want to use for the connection?
I am trying to use LinqConnect via LINQPad to connect to an Oracle server. The schema that I need to use is NOT the default user schema, and I have access to way too many schemas to use the "Include all schemas" option...it crashes trying to handle them all.
Thanks.
LinqConnect to Oracle with different Schema
Re: LinqConnect to Oracle with different Schema
A similar question has been discussed here http://forums.devart.com/viewtopic.php?t=27442.
Currently, there is no such parameter in the Oracle connection string. We will consider the possibility to add this parameter to the connection string, but we can't tell any timeframe at the moment.
You can try performing the following steps:
- create new connection in LINQPad (Add connection -> Build data context automatically -> Devart LinqConnect);
- specify the necessary connection properties;
- set the "Initialization Command" to "ALTER SESSION SET CURRENT_SCHEMA=SCHEMA_NAME" via Advanced connection properties in the Connection Editor (the Advanced button in the Devart LinqConnect Configuration window);
- save the changes.
Please tell us if this helps.
Currently, there is no such parameter in the Oracle connection string. We will consider the possibility to add this parameter to the connection string, but we can't tell any timeframe at the moment.
You can try performing the following steps:
- create new connection in LINQPad (Add connection -> Build data context automatically -> Devart LinqConnect);
- specify the necessary connection properties;
- set the "Initialization Command" to "ALTER SESSION SET CURRENT_SCHEMA=SCHEMA_NAME" via Advanced connection properties in the Connection Editor (the Advanced button in the Devart LinqConnect Configuration window);
- save the changes.
Please tell us if this helps.