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, and fast connection failover.

There are three types of ODP.NET drivers: ODP.NET, Managed Driver; ODP.NET, Unmanaged Driver; and ODP.NET Core. ODP.NET, Managed Driver is 100% .NET code. Developers deploy a single assembly in a deployment package smaller than 10 MB. ODP.NET, Unmanaged Driver contains more features than the managed driver since it can access functionality built into the Oracle Database Client. ODP.NET Core is designed for multi-platform .NET Core applications.

Download ODP.NET in ODAC 12.2c Release 1 with support for .NET Framework 4.6.2 and 4.7; Application Continuity; sharding; and connection pooling support for pluggable databases, edition-based redefinition, and Database Resident Connection Pooling. ODP.NET, Managed Driver is also available as a NuGet package.

Download ODP.NET Core Beta for multi-platform support on Linux and Windows.

Technical Information

 Hiding .NET Outages: Application Continuity White Paper (PDF), Transaction Guard White Paper (PDF), and more on Oracle High Availability
 Oracle Data Access Components 12.2c Release 1 Data Sheet (PDF)
 Oracle Data Access Components 12c Release 4 Data Sheet (PDF)
 Oracle Data Access Components 12c Release 3 Data Sheet (PDF)
 Oracle Data Access Components 12c Release 2 Data Sheet (PDF)
 Oracle Data Access Components 12c Release 1 Data Sheet (PDF)
 Oracle OpenWorld 2017: Oracle on .NET presentations
 Oracle By Example for Visual Studio 2015, 2013, 2012, 2010, and 2008: Step by step ODP.NET tutorials
 Oracle Data Access Components 11.2 Release 4 Data Sheet (PDF)
 Learn Why and How to Migrate from System.Data.OracleClient to ODP.NET
 What's New for ODP.NET 11.1.0.7.20 Technical White Paper (PDF)
 ODP.NET 11g Technical White Paper (PDF)
 ODP.NET Tips and Tricks
 New ODP.NET Features by Oracle Release Version
 ODP.NET FAQ

Downloads, Discussion Forum, and Sample Code

 Download ODP.NET via ODAC
 ODP.NET Discussion Forum
 GitHub - Oracle .NET Sample Code Repository
 

Video

 YouTube - Oracle .NET
 

Technical Articles

 Build an Oracle Database .NET Application with Visual Studio 2010, 2008/2005, or 2003 - beginner article for Oracle .NET developers
 Use Entity Framework with ODP.NET Sept 2011
 ODP.NET Messaging Applications with Oracle Streams Advanced Queuing Nov 2009
 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
 Globalize and Personalize ODP.NET Applications Sept 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 in Oracle Database 10 g Release 2 Jan 2006
 New Oracle Database 10 g Release 2 LOB Features in ODP.NET Nov 2005
 Securing a .NET Application on the Oracle Database Oct 2005
 Optimizing Result Set Retrieval Using ODP.NET and Ref Cursors Sept 2005
 Using Bind Variables in ODP.NET Sept 2005