Does ODP.NET require Oracle Client installation

by

Alex Keh from Oracle in aug 2013 says:

Managed ODP.NET is released. It is currently part of the Oracle DB 12c
client. To use managed ODP.NET, you have to download and install the
DB client. From there, you can extract just the managed ODP.NET
assembly and setup files. These files are less than 10 MB and can be
deployed to any target machines.

Currently, we are packaging a stand alone managed ODP.NET release and
ODAC 12 release that will be much smaller. This will be released on
OTN shortly.

If you can wait a couple of days, ODAC 12c will be out on OTN and you can download that version. That will be our latest and greatest
managed ODP.NET version

====

We do not plan to put managed ODP.NET on NuGet. We believe that the
managed ODP.NET download with ODAC will provide the same benefits of
NuGet in terms of assembly isolation and download size.

There’s a thread discussing whether Oracle should provide managed
ODP.NET NuGet support. Once you use ODAC 12c, I would like to know
your thoughts on whether NuGet support is still necessary.
https://forums.oracle.com/thread/2559445

Nuget managed ODP.NET:

PM> Install-Package Oracle.ManagedDataAccess

So what is the problem anyway?
Basically up until now, ODP.NET was a .NET layer that talks to the Oracle client .dll files, a small fact that had many implications:

  • Large installation footprint (several hundreds of Mb)
  • Tough deployment to remote machines – needs to install ODP.NET on client
    machine or deploy large files
  • Challenging when working with several versions, 32bit/64bit os and applications

So what is it?

The managed driver is basically a single .dll file with a .Net native implementation of ODP.NET.
That means no Oracle Client is needed, and now native code is behind the scenes. XCopy installation can be done easily.

Major benefits:

  • Small footprint
  • Compiled as any cpu so it can work on 32bit/64bit OS
    and application smoothly. Easy to manage multiple versions on the
    same machine
  • Can be deployed as a simple reference in the application
    bin directory.

So what’s the catch?

  • Not all features are supported (although most of them are… ) you
    can find out more on the documentation
  • Namespace is changed from
    Oracle.DataAccess.Client to Oracle.ManagedDataAccess.Client
  • Performance differences are still not clear. (The old) Native code
    always perform very efficiently, but on the other hand 100% managed
    code has it’s performance benefits.

Please note that the Native-Code ODP.NET is still very much available. The managed version (at least for now) comes in addition to the native one.

References: http://oracleatdotnet.blogspot.com.es/2013/07/odpnet-managed-driver-beta-2.html

Differences between the ODP.NET Managed Driver and Unmanaged Driver
http://docs.oracle.com/html/E41125_02/intro004.htm

Features of Oracle Data Provider for .NET
http://docs.oracle.com/database/121/ODPNT/features.htm#ODPNT0007

More Related Contents:

  1. Can you use Microsoft Entity Framework with Oracle? [closed]
  2. Managed ODP.NET driver does not show up in Data Source dialog
  3. BadImageFormatException. This will occur when running in 64 bit mode with the 32 bit Oracle client components installed
  4. The provider is not compatible with the version of Oracle client
  5. How to connect to Oracle 11 database from . net
  6. Bulk Insert to Oracle using .NET
  7. How to cancel a long-running Database operation?
  8. Deciphering the .NET clr20r3 exception parameters P1..P10
  9. Array versus List: When to use which?
  10. Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths – why?
  11. .NET Equivalent of Snipping Tool
  12. What is the correct SQL type to store a .Net Timespan with values > 24:00:00?
  13. What does CultureInfo.InvariantCulture mean?
  14. Are there .NET implementation of TLS 1.2?
  15. What is a “first chance exception”?
  16. “Or” equivalent in Linq Where() lambda expression
  17. Circular References Cause Memory Leak?
  18. Determine .NET Framework version for dll
  19. XmlSerializer: remove unnecessary xsi and xsd namespaces
  20. GZip Compression On IIS 7.5 is not working
  21. How to solve “unable to switch the encoding” error when inserting XML into SQL Server
  22. How to generate service reference with only physical wsdl file
  23. Coerce a WPF TextBox not working anymore in .NET 4.0
  24. Windows or Visual Studio 2022 can’t find the latest installed .NET SDK due to bitness
  25. What is the difference between Culture and UICulture?
  26. When ServiceStack authentication fails, do not redirect?
  27. What is a .snk for?
  28. NuGet for solutions with multiple projects
  29. Is project.json deprecated?
  30. Getting exact error type in from DbValidationException

Leave a Comment