Connect Linqpad to Oracle
...using an IQ Connection.
Step 2, click
view more drivers
Step 3, Find "IQ Driver - for MySQL, SQLite, Oracle"
click "Download & Enable Driver"
Now when you choose "Add Connection" you'll forever see "IQ" listed.
Direct (Oracle Client not Required)
(it has these limitations: http://www.devart.com/dotconnect/oracle/docs/DirectMode.html
Now here are the tricks....
Given this connection string
"Data Source=SRV1238xx1.example.com:1234/DS128x; User Id=UserUser; Password=PassPass;"
On the dialog, you would set:
Server = SRV1238xx1.example.com User = UserUser password = PassPass
Give it a friendly name
Then on the 'Advanced' tab Set:
Port = 1234
And in addition connection string options, type:
Note the space between Service and Name
Optionallly, you can set a default schema, if you know a schema that you're most interested in. (It's not mentioned in the example connection string above. Setting one will allow you to browse the schema details: list of tables, views, columns, etc.)
test to test. And Bob's your Uncle.