Oracle Data Provider for .NET
Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, self-tuning statement cache, Application Continuity, and Fast Connection Failover. Developers can also use popular .NET features, such as Entity Framework Core.
There are three driver types: ODP.NET Core; ODP.NET, Managed Driver; and ODP.NET, Unmanaged Driver. ODP.NET Core is designed for multi-platform .NET (Core) applications. 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.
The latest ODP.NET 21c supports .NET 7, Entity Framework Core 7, user-defined types, binary JSON, Azure Active Directory, Client Initiated Continuous Query Notification, and more.
Get the Details
Downloads and Documentation
Office Hours and Videos
Oracle .NET Office Hours - Join live monthly webcasts with Oracle product managers to ask questions
ODP.NET Core Introduction (9:38)
Managed ODP.NET Introduction (3:42)
Oracle Entity Framework Core 6 Demo (5:38)
Oracle Entity Framework Core Introduction (22:15)
ODP.NET 21c: What's New (5:55)
Oracle Database World 2021: What's New for Oracle .NET and Visual Studio Code Developers (30:36)
Technical Information
Connect Power BI to Oracle Databases
LiveLab: .NET Development with Oracle Autonomous Database Quick Start
Oracle Data Access Components 21c Data Sheet (PDF)
Hiding .NET Outages: Application Continuity White Paper (PDF), Transaction Guard White Paper (PDF), and more on Oracle High Availability
New ODP.NET Features by Oracle Release Version
Oracle Data Access Components 19c Data Sheet (PDF)
Tutorial: ODP.NET Core Getting Started - uses ASP.NET Core and Configuration API
Oracle By Example for Visual Studio 2015, 2013, 2012, 2010, and 2008: Step by step ODP.NET tutorials
Learn Why and How to Migrate from System.Data.OracleClient to ODP.NET
Sample Code and Discussion Forum
Technical Articles
Use Entity Framework with ODP.NET Sept 2011
Use ODP.NET Array Binding to Increase Performance Sept 2009
ODP.NET Explicit and Implicit Transactions May 2009
ODP.NET Xcopy Deployment with Instant Client Nov 2008
ODP.NET Client Result Cache Jul 2008
Build Oracle User-Defined Type Applications in .NET May 2008
Passing Array Parameters in ODP.NET Jan 2007
Improve ODP.NET Performance July 2006
ODP.NET Database Change Notification, Part 1 Mar 2006
ODP.NET Database Change Notification, Part 2 May 2006
Using Input REF Cursors with ODP.NET Jan 2006
New ODP.NET 10.2 LOB Features Nov 2005
Optimizing Result Set Retrieval Using ODP.NET and Ref Cursors Sept 2005
Using Bind Variables in ODP.NET Sept 2005
For more information about developing Oracle .NET apps, visit the Oracle .NET Developer Center.