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 advanced security. The data provider can be used with the latest .NET Framework 4.5.1 version.
ODP.NET makes using Oracle from .NET more flexible, faster, and more stable. ODP.NET includes many features not available from 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 release in ODAC 12c Release 2. This release includes the fully-managed ODP.NET, multitenant container database support, Identity column support, native PL/SQL Boolean data type, and Transaction Guard.
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 2 Data Sheet (PDF)|
|Oracle Data Access Components 12c Release 1 Data Sheet (PDF)|
|Oracle OpenWorld 2013: Oracle on .NET presentations|
|Oracle OpenWorld 2012: Oracle on .NET presentations|
|Oracle By Example for Visual Studio 2010 and 2008: Step by step ODP.NET tutorials for getting started, performance tuning, DB change notification, and user-defined types|
|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 18.104.22.168.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).
Webinars and Recorded Presentations
If you missed any of the OTN Virtual Developer Day or ODTUG webinars, you can watch the replays. The ODTUG webinars require the GoToMeeting codec, G2M3, to play the video, which can be downloaded here.
|OTN Virtual Developer Day -- Database -- includes .NET developer track.|
|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|