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 2. This release includes fully-managed ODP.NET, multitenant container database support, Identity column support, native PL/SQL Boolean data type, and Transaction Guard. Or download the new ODP.NET Beta with support for Entity Framework 6 Code First and Code First Migrations, NuGet, .NET 4.5.2, and ODP.NET, Managed Driver XML DB APIs.

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 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 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
 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
 

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