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.

ODP.NET 18c includes support for .NET Framework 4.7.1 and 4.7.2; OracleCredential class to improve password security; and .NET Core running on both Linux and Windows.

Download ODP.NET as part of ODAC or download ODP.NET Core for multi-platform support on Linux and Windows.


 Video: ODP.NET Core Introduction
 Getting Started Tutorial - uses ASP.NET Core and Configuration API
 Sample Code

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 18c Data Sheet (PDF)
 Oracle OpenWorld 2018: Oracle on .NET presentations
 Oracle By Example for Visual Studio 2015, 2013, 2012, 2010, and 2008: Step by step ODP.NET tutorials
 Learn Why and How to Migrate from System.Data.OracleClient to ODP.NET
 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
 GitHub - Oracle .NET Sample Code Repository


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