Oracle.ManagedDataAccess 23.7.0

Prefix Reserved
.NET Framework 4.7.2 This package targets .NET Framework 4.7.2. The package is compatible with this framework or higher. 
dotnet add package Oracle.ManagedDataAccess --version 23.7.0                

                    
                

            
NuGet\Install-Package Oracle.ManagedDataAccess -Version 23.7.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="Oracle.ManagedDataAccess" Version="23.7.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Oracle.ManagedDataAccess --version 23.7.0                

                    
                

            
#r "nuget: Oracle.ManagedDataAccess, 23.7.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install Oracle.ManagedDataAccess as a Cake Addin
#addin nuget:?package=Oracle.ManagedDataAccess&version=23.7.0

// Install Oracle.ManagedDataAccess as a Cake Tool
#tool nuget:?package=Oracle.ManagedDataAccess&version=23.7.0

Oracle Logo

Oracle.ManagedDataAccess 23.7.0

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

December 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

  • Sessionless Transaction Support
  • Set Rows to Fetch per Round Trip
  • Set Database Roles on Connections
  • More Configuration Provider Settings
  • OracleConnection Encryption & Checksum Properties
  • Enhanced Password Security with OracleOpaqueString
  • Server Name Indication (SNI) for TLS
  • Sharding Split Partitionset

Bug Fixes since Oracle.ManagedDataAccess.Core 23.6.0

  • Bug 33068315 - UDT: INCORRECT TIMEZONE VALUE INSERTED TO DATABASE IF CLIENT AND SEVER TIMEZONE FILE VERSIONS MISMATCH
  • Bug 36710738 - ASYNC CANCEL RETURNS ORA-01013 INSTEAD OF OPERATIONCANCELLEDEXCEPTION
  • Bug 36838000 - UDT: VALIDITY OF NESTED USER DEFINED TYPES ARE NOT RECOGNIZED
  • Bug 37044756 - APPLICATION HANG AFTER A DATAGUARD SWITCHOVER WHEN USING ODP.NET MANAGED DRIVER
  • Bug 37044799 - SEPS: SUPPORT DEFAULT USERNAME AND PASSWORD
  • Bug 37144163 - ORA-50000: CONNECTION REQUEST TIME OUT USING OPENASYNC UNDER HIGH LOAD

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.

Product Compatible and additional computed target framework versions.
.NET Framework net472 is compatible.  net48 was computed.  net481 was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (254)

Showing the top 5 NuGet packages that depend on Oracle.ManagedDataAccess:

Package Downloads
DistributedLock

Provides easy-to-use mutexes, reader-writer locks, and semaphores that can synchronize across processes and machines. This is an umbrella package that brings in the entire family of DistributedLock.* packages (e. g. DistributedLock.SqlServer) as references. Those packages can also be installed individually.
DapperExtensions

A small library that complements Dapper by adding basic CRUD operations (Get, Insert, Update, Delete) for your POCOs. For more advanced querying scenarios, Dapper Extensions provides a predicate system.
Oracle.ManagedDataAccess.EntityFramework

This NuGet package is for ODP.NET, Managed Driver applications that use Code First and/or Entity Framework 6 applications. It will add and configure the Oracle Entity Framework assembly for your application.
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.
DistributedLock.Oracle

Provides a distributed lock implementation based on Oracle Database

GitHub repositories (38)

Showing the top 5 popular GitHub repositories that depend on Oracle.ManagedDataAccess:

Repository Stars
ServiceStack/ServiceStack
Thoughtfully architected, obscenely fast, thoroughly enjoyable web services for all
dotnetcore/FreeSql
🦄 .NET aot orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 虚谷 orm, 国产 orm, Clickhouse orm, DuckDB orm, TDengine orm, QuestDB orm, MsAccess orm.
fluentmigrator/fluentmigrator
Fluent migrations framework for .NET
linq2db/linq2db
Linq to database provider.
nhibernate/nhibernate-core
NHibernate Object Relational Mapper
Version Downloads Last updated
23.7.0 2,903 12/24/2024
23.6.1 46,726 11/7/2024
23.6.0 51,754 10/2/2024
23.5.1 81,787 8/16/2024
23.5.0 59,268 7/11/2024
23.4.0 127,971 5/2/2024
23.3.3-dev 789 4/19/2024
23.3.2-dev 2,383 3/11/2024
23.3.1-dev 6,724 12/12/2023
23.3.0-dev 3,122 10/17/2023
23.2.0-dev 5,104 7/29/2023
21.17.0 669 12/24/2024
21.16.0 17,279 10/2/2024
21.15.0 37,176 7/11/2024
21.14.0 75,888 4/11/2024
21.13.0 277,938 1/1/2024
21.12.0 216,018 10/9/2023
21.11.0 203,729 7/25/2023
21.10.0 888,466 4/8/2023
21.9.0 526,853 1/19/2023
21.8.0 182,802 10/18/2022 21.8.0 has at least one vulnerability with high severity.
21.7.0 170,595 8/4/2022 21.7.0 has at least one vulnerability with high severity.
21.6.1 298,251 5/4/2022 21.6.1 has at least one vulnerability with high severity.
21.5.0 275,882 1/4/2022 21.5.0 has at least one vulnerability with high severity.
21.4.0 238,259 10/27/2021 21.4.0 has at least one vulnerability with high severity.
19.26.0 238 12/24/2024
19.25.0 7,566 10/2/2024
19.24.0 12,738 7/11/2024
19.23.0 17,239 4/11/2024
19.22.0 48,226 1/1/2024
19.21.0 41,017 10/9/2023
19.20.0 47,819 7/25/2023
19.19.0 85,413 4/8/2023
19.18.0 208,333 1/19/2023
19.17.0 40,996 10/18/2022 19.17.0 has at least one vulnerability with high severity.
19.16.0 41,892 8/4/2022 19.16.0 has at least one vulnerability with high severity.
19.15.1 102,301 6/7/2022 19.15.1 has at least one vulnerability with high severity.
19.14.0 221,067 1/4/2022 19.14.0 has at least one vulnerability with high severity.
19.13.0 137,562 10/8/2021 19.13.0 has at least one vulnerability with high severity.
19.11.0 1,243,542 3/16/2021 19.11.0 has at least one vulnerability with high severity.
19.10.1 791,350 1/12/2021 19.10.1 has at least one vulnerability with high severity.
19.10.0 344,357 11/16/2020 19.10.0 has at least one vulnerability with high severity.
19.9.0 335,978 9/8/2020 19.9.0 has at least one vulnerability with high severity.
19.8.0 630,199 7/9/2020 19.8.0 has at least one vulnerability with high severity.
19.7.0 568,328 4/21/2020 19.7.0 has at least one vulnerability with high severity.
19.6.0 1,175,822 12/6/2019 19.6.0 has at least one vulnerability with high severity.
19.5.0 336,516 10/16/2019 19.5.0 has at least one vulnerability with high severity.
19.3.1 810,375 7/11/2019 19.3.1 has at least one vulnerability with high severity.
19.3.0 474,874 5/22/2019 19.3.0 has at least one vulnerability with high severity.
18.15.1 11,254 2/3/2023
18.15.0 16,643 8/5/2021
18.6.0 441,281 3/20/2019
18.3.0 1,964,407 8/29/2018
12.2.20230118 28,858 2/3/2023
12.2.20220118 54,235 12/7/2021
12.2.1100 3,529,582 5/31/2017
12.1.24230118 7,562 2/3/2023
12.1.24220118 50,450 12/7/2021
12.1.24160719 1,372,708 9/17/2016
12.1.24160419 474,534 4/27/2016
12.1.2400 977,047 10/14/2015
12.1.22 451,174 6/23/2015
12.1.21 379,421 1/16/2015