Oracle.ManagedDataAccess 23.4.0

Oracle Logo

Oracle.ManagedDataAccess 23.4.0

Release Notes for Oracle Data Provider for .NET, Managed Driver NuGet Package

April 2024

Managed Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database for .NET Framework and is 100% managed code. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including AI vectors, Real Application Clusters, Application Continuity, JSON Relational Duality, and Fast Connection Failover.

This document provides information that supplements the Oracle Data Provider for .NET (ODP.NET) documentation.

New Features

  • Artificial Intelligence Vector Search
  • OracleConfiguration.ConfigurationProviders Public Property

Bug Fixes since Oracle.ManagedDataAccess.Core 23.3.3-dev

Bug 36508558 - HOSTNAME IN TNSNAMES PREMATURELY RESOLVED TO IP ON CLIENT SIDE WHEN USING HTTPS_PROXY Bug 36442140 - BULKCOPY: CLOB/NCLOB DATA THAT IS SENT TO DATABASE VIA WRITETOSERVER() GETS CORRUPTED Bug 36417060 - ORA-12599 ENCOUNTERD UPON EXECUTING STATEMENTS WITH NA ENABLED AFTER FAILOVER Bug 36120362 - HIT "ORA-01008" OR "ORA-01722" WHEN EXECUTE QUERY STATEMENT WITH COMMENTS INCLUDING SINGLE QUOTE AND BINDBYNAME = TRUE

Installation Changes

The following app/web.config entries are added when installing the managed ODP.NET NuGet package to your application:

  1. Configuration Section Handler

A configuration section handler entry is added to the app/web.config to enable applications to add an <oracle.manageddataaccess.client> section for ODP.NET, Managed Driver-specific configuration.

Note: For a web app, if the same config section handler for "oracle.manageddataaccess.client" also exists in machine.config but the "Version" attribute values are different, an error message "There is a duplicate 'oracle.manageddataaccess.client' section defined." may be observed at runtime. To resolve the error, remove the "oracle.manageddataaccess.client" config section handler entry in the machine.config. If other applications on the machine depend on this machine.config entry, move the config section handler entry to each application's web.config file.

  1. DbProviderFactories

The DbProviderFactories entry is added for applications that use DbProviderFactories and DbProviderFactory classes. Any DbProviderFactories entry for "Oracle.ManagedDataAccess.Client" in the machine.config will be ignored.

  1. Dependent Assembly

The dependent assembly entry is created to ignore policy DLLs for Oracle.ManagedDataAccess.dll. It directs the app to always use the Oracle.ManagedDataAccess.dll version that is specified by the "newVersion" attribute in the "bindingRedirect" element. The "newVersion" attribute corresponds to the Oracle.ManagedDataAccess.dll version which came with the NuGet package.

  1. Data Sources

The data sources entry is added to provide a template on how a data source can be configured in the app/web.config. Simply rename the sample data source to an alias of your choosing; modify the PROTOCOL, HOST, PORT, SERVICE_NAME as required; and un-comment the "dataSource" element. Once that is done, the alias can be used as the "data source" attribute in your ODP.NET connection string.

Copyright (c) 2024, Oracle and/or its affiliates.

Showing the top 20 packages that depend on Oracle.ManagedDataAccess.

Packages Downloads
EnterpriseLibrary.Data.NetCore
The Data Access Application Block simplifies the development of tasks that implement common data access functionality. Applications can use this application block in a variety of situations, such as reading data for display, passing data through application layers, and submitting changed data back to the database system.
 17
EnterpriseLibrary.Data.NetCore
The Data Access Application Block simplifies the development of tasks that implement common data access functionality. Applications can use this application block in a variety of situations, such as reading data for display, passing data through application layers, and submitting changed data back to the database system.
 11
EnterpriseLibrary.Data.NetCore
The Data Access Application Block simplifies the development of tasks that implement common data access functionality. Applications can use this application block in a variety of situations, such as reading data for display, passing data through application layers, and submitting changed data back to the database system.
 10
EnterpriseLibrary.Data.NetCore
The Data Access Application Block simplifies the development of tasks that implement common data access functionality. Applications can use this application block in a variety of situations, such as reading data for display, passing data through application layers, and submitting changed data back to the database system.
 9

.NET Framework 4.7.2

Version Downloads Last updated
23.7.0 3 12/29/2024
23.6.1 7 11/10/2024
23.6.0 7 10/07/2024
23.5.1 7 08/26/2024
23.5.0 7 07/15/2024
23.4.0 22 05/31/2024
23.3.3-dev 22 05/31/2024
23.3.2-dev 14 03/14/2024
23.3.1-dev 6 01/29/2024
23.3.0-dev 7 12/28/2023
23.2.0-dev 6 12/28/2023
21.17.0 1 12/28/2024
21.16.0 5 10/07/2024
21.15.0 9 07/15/2024
21.14.0 23 05/31/2024
21.13.0 6 02/13/2024
21.12.0 8 12/28/2023
21.11.0 6 12/28/2023
21.10.0 7 08/29/2023
21.9.0 8 02/17/2024
21.8.0 7 02/17/2024
21.7.0 6 02/17/2024
21.6.1 5 02/17/2024
21.5.0 6 02/17/2024
21.4.0 7 02/17/2024
19.26.0 2 12/29/2024
19.25.0 3 10/07/2024
19.24.0 6 07/15/2024
19.23.0 22 05/31/2024
19.22.0 6 01/06/2024
19.21.0 7 12/28/2023
19.20.0 8 01/29/2024
19.19.0 9 08/31/2023
19.18.0 8 08/31/2023
19.17.0 8 08/24/2023
19.16.0 11 12/07/2023
19.15.1 8 08/27/2023
19.14.0 8 08/30/2023
19.13.0 9 08/30/2023
19.12.0 10 03/20/2023
19.11.0 8 08/29/2023
19.10.1 7 08/31/2023
19.10.0 7 08/28/2023
19.9.0 6 02/17/2024
19.8.0 6 02/17/2024
19.7.0 7 02/17/2024
19.6.0 7 02/17/2024
19.5.0 6 02/17/2024
19.3.1 6 02/17/2024
19.3.0 7 02/17/2024
18.15.1 6 08/31/2023
18.15.0 7 08/28/2023
18.6.0 5 02/17/2024
18.3.0 7 02/17/2024
12.2.20230118 11 08/25/2023
12.2.20220118 9 08/29/2023
12.2.1100 9 08/28/2023
12.1.24230118 10 08/26/2023
12.1.24220118 9 08/24/2023
12.1.24160719 12 08/30/2023
12.1.24160419 10 08/31/2023
12.1.2400 11 08/26/2023
12.1.22 6 08/30/2023
12.1.21 8 08/30/2023