Menu
Which of the above should I use. Please let me know with respect to the following aspects:
721
ODP.NET, Managed Driver consists of fewer DLLs than ODP.NET, Unmanaged Driver. Hence, the installation size of the Managed Driver is smaller than that of the Unmanaged Driver. ODP.NET Core is similar to the ODP.NET, Managed Driver yet with reduced set of provided APIs. Both use the same namespaces.
ODP.NET, Managed Driver is 100% managed code . NET Framework provider. Developers deploy a single assembly in a deployment package smaller than 10 MB. ODP.NET, Unmanaged Driver is the traditional Oracle ADO.NET provider that uses the Oracle Database Client. ODP.NET 21c add support for user-defined types, .
ManagedDataAccess. dll , that allows you to connect to an Oracle database without any other software installed. In fact, you don't even need to "install" Managed ODP.NET, you just need the dll, and you can safely deploy it to servers with no software installed.
the only way you should go is the ODP.NET, the OracleClient has been deprecated and will not be supported any longer in future versions of the .NET Framework.
check here: Microsoft OracleClient Deprecated
Edit: from the linked article:
Oracle's free Oracle Data Provider for .NET (ODP.NET)
ODP.NET 11g is compatbile with all versions of Oracle Database back to 9.2, and multiple versions can coexist in a single OS
102
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
