This replaces the more general suggestion "Support Oracle / MySQLl / SQLite". Vote here if you need Oracle support.
Oracle support is now complete – let me know how you get on. Go to Add Connecton | View More Drivers and download the IQ driver. You’ll need LINQPad v2.35/4.35 or later. This driver is free of charge.
Kellerman Software has an Oracle LINQ provider
Craig Main commented
I would like to be able to do something like this.
UPDATE blah blah
SELECT blah blah
I seem unable to execute multiple statements?
It would be great to be able to execute a few statements in a transaction. Does the driver support this?
How do I type multiple sql statements when I set language to sql?
semi doesn't seem to work. It would be nice to be able to execute more than one statement.
Well, I was not lucky.
After I discovered, that Oracle will be accessible only with beta version of Pad, I found and downloaded v.4.35.8. However, the attempt to install IQ driver displays message "Invalid driver file".
And I cannot find where I could download IQ driver directly from...
I am a student and trying to learn LINQPad with Oracle. I installed Oracle as a desktop server. When I connect LINQPad it asks for the server name. I tried localhost and localhost:1521. I am stumped on how to conect it.
@BehreJue: You can execute native SQL - just change the query language to SQL.
First of all thanks for the great tool and the great book.
The Support for Oracle is great, it could be impoved by letting one add more tables and allow for executing handwritten sql like the link to sql provider does with this.ExecuteQuery / this.ExecuteCommand.
@robert: Sure - you're welcome to use it for commercial purposes - the libraries you need are in %programdata%\linqpad\drivers. However, you'll need to buy a license from DevArt for the Oracle ADO.NET provider in order to reference that library from your own executable: http://www.devart.com/dotconnect/oracle/. I'm using the standard edition ($150) and so far I've had no complaints. I don't use Oracle's own driver because it's big and bloated and cannot be xcopy-deployed. DevArt also offer a pro edition of their driver which includes its own LINQ translation engine. This might be worth looking at because it includes design-time support in VS and its LINQ translation ability is almost as good as the IQ library (in some ways better).
Is it OK to use this driver for commercial programs or is it just for use with the LINQPad?
Great! Thanks a lot for hearing us out. It's working great!
Actually, I'm surprised there isn't Oracle support. We now have DevArt's Oracle drivers, but I have to go through a lot of rigmarole to be able to query an Oracle table that isn't really necessary to my application.
I have just got a new job where we don't use sql server but oracle db instead. I also have just found out about existence of linqpad and it is so great program that I have got depressed after realizing that it does not support oracle. I hope it will support oracle soon as I want to buy it for myself and for my sister (who luckily for her still uses sql server)
This will be a great addition and my purpose to start using LINQPad as I use .NET with Oracle
Oracle , Big Market, thought I don't like it , but I think Support Oracle Will Do GOOD for LINQPad.
Voted for oracle!
Would be a great addition.
vote for LinqPad to Oracle.
Oracle!! LinqPad!! Please!!!
Oracle is the most used, it would be great to have LINQPad for Oracle.
Mikael Selander commented
For now I've been working with a custom EF class that uses the devart oracle provider. Until Oracle releases it's own Linq provider it's good enough.