LINQPad and Oracle

oracle linqpad
user118190 picture user118190 · Sep 3, 2009 · Viewed 7.8k times · Source

Does LINQPad work with Oracle? Has anyone tried? What do you suggest?

Answer

Goyuix picture Goyuix · Jul 25, 2011

As of beta version 4.35, LINQPad supports Oracle fully - you can now do "LINQ to Oracle" queries. I believe it uses the DevArt dotConnect libraries for managing this great feat. Further, in addition to native OCI support, it also supports a direct mode which does not require the Oracle OCI DLLs to be present.

To enable this feature you will need to simply add a new data connection in LINQPad, and when asked which driver to use - click the View more drivers... button. You can then install the IQ Driver and use it for querying Oracle, MySQL and SQLite databases.

IQ Connection Options showing Oracle, MySQL and SQLite support

Related questions

How to submit changes in LinqPad

I have a problem with committing changes in LinqPad. I am using Oracle database over IQ driver in LinqPad. I can retrieve data but I don't know how to submit changes to database. I retrieve data from database: var items = …

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More