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, XML DB, and self-updating client caches.

ODP.NET makes using Oracle from .NET more flexible, faster, and more stable. ODP.NET includes many features not found in other .NET drivers, including flexible LOB data types, self-tuning, run-time connection load balancing, fast connection failover, and Advanced Queuing.

Download the latest ODP.NET production release in ODAC 12c Release 4 with support for .NET Framework 4.6; ODP.NET, Managed Driver security, encryption, and Windows installer; and Transaction Guard improvements.The April, 2016 NuGet release includes support for data integrity/checksumming and TLS 1.1 and 1.2.

ODP.NET, Managed Driver is 100% .NET code. Developers can deploy a single assembly, side by side with other ODP.NET versions easily in a deployment package smaller than 10 MB.

Technical Information

 Oracle Data Access Components 12c Release 4 Data Sheet (PDF)
 Oracle Data Access Components 12c Release 3 Data Sheet (PDF)
 Hiding .NET Outages: Transaction Guard White Paper and Zero Downtime Presentation (PDF)
 Oracle Data Access Components 12c Release 2 Data Sheet (PDF)
 Oracle Data Access Components 12c Release 1 Data Sheet (PDF)
 Oracle OpenWorld 2015: Oracle on .NET presentations
 Oracle By Example for Visual Studio 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 Technical White Paper (PDF)
 ODP.NET 11g Technical White Paper (PDF)
 ODP.NET Tips and Tricks
 New ODP.NET Features by Oracle Release Version

Downloads, Discussion Forum, and Sample Code

 Download ODP.NET via ODAC
 ODP.NET Discussion Forum
 Oracle .NET Sample Code Repository
Additional sample code is located in the ORACLE_HOME\\samples directory, part of the ODP.NET installation (non-xcopy version).


Oracle .NET YouTube videos and recorded ODTUG webinars are great ways to learn more about ODP.NET. The ODTUG webinars require the GoToMeeting codec, G2M3, to play the video, which can be downloaded here.
 YouTube - Oracle .NET
 ODTUG: Maximize Performance with .NET Caching for Oracle Database: Client Result Cache, Continuous Query Notification, and TimesTen
 ODTUG: Entity Framework, LINQ, and WCF Data Services for Oracle Database

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