Are there any .NET data providers for Oracle that do not require the Oracle Client to be installed?

Asked 14/1, 2009 at 19:2 Answered 29/10, 2013 at 17:47

I am developing a rich client application that will use the Entity Framework (with DevArt's DotConnect for Oracle) to connect to a central Oracle database. However, I have found that this scenario requires every client machine to have the Oracle client installed in order to connect to the Oracle 10g server. Is there an easy way around this? Do the other types of Oracle providers (ODP.NET, EntLib Data, MS .NET Oracle provider) have the same requirements?

EDIT: Thanks to tuinstoel, I've done more research and confirmed that DevArt's dotConnect can be run in Direct mode which does not require the Oracle Client software to be installed. This should solve my issue of connecting to Oracle using the Entity Framework. I also plan to connect to Oracle using a DbConnection, for which I can also use DevArt's Oracle provider. My issue now is that I cannot get the Direct mode to work.

Borsch answered 14/1, 2009 at 19:2 Comment(0)

odp.net requires the installation of the Oracle client.

I read on Devart's site that you don't (always) need a Oracle client when you use Dotconnect to Oracle:

dotConnect for Oracle offers two connection modes to the Oracle server: connection through the Oracle Call Interface and direct connection over TCP/IP. Applications written with dotConnect for Oracle are easy to deploy, do not require installation of Oracle Client Software, and tend to be faster than those that use other data connectivity solutions.

So why this question?

Haymow answered 14/1, 2009 at 19:30 Comment(1)

Hmm... That's not what I have found. I'll have to go back to my prototype and make sure this a valid question. – Borsch 15/1, 2009 at 0:1

Yes there are third party providers... see this one

Thickwitted answered 14/1, 2009 at 19:29 Comment(0)

odp.net requires the installation of the Oracle client.

I read on Devart's site that you don't (always) need a Oracle client when you use Dotconnect to Oracle:

dotConnect for Oracle offers two connection modes to the Oracle server: connection through the Oracle Call Interface and direct connection over TCP/IP. Applications written with dotConnect for Oracle are easy to deploy, do not require installation of Oracle Client Software, and tend to be faster than those that use other data connectivity solutions.

So why this question?

Haymow answered 14/1, 2009 at 19:30 Comment(1)

Hmm... That's not what I have found. I'll have to go back to my prototype and make sure this a valid question. – Borsch 15/1, 2009 at 0:1

The new managed provider for Oracle is available on nuget and does not require you to install the full Oracle client.

http://www.nuget.org/packages/odp.net.managed/

Utas answered 29/10, 2013 at 17:47 Comment(1)

Old answer, but take note that the Managed client isn't even REMOTELY at parity with the native client. – Og 14/1, 2019 at 13:57

Recommended topics

Hot tags