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.
|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 220.127.116.11.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|
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\odp.net\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|
|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|