Friday, April 04, 2014

Oracle Data Provider ODP.NET is available in two flavors

Oracle Data Provider for .NET (ODP.NET) is a free, high performance ADO-NET complinat data access provider. Using this .NET Developers can access Oracle databases using .NET Languages. ODP.NET supports all ADO.NET and .NET Framework features.

You can download it from here:

In the download look for Oracle Data Provider for .NET and is part of the Oracle Data Access Components (ODAC)12.1.

ODP.NET is available in two forms:
  • ODP.NET Unmanaged Driver --Some librabries compiled to machine code rather than .NET code
  • ODP.NET 12.1 Managed Driver - Completly compiled to .NET Byte code and runs inside Common Language Runtime
These two are comparable to JDBC thick and thin clients.

The managed driver is really 'thin' comprising of just two dlls with less than 10MB size. It is totally self-contained requiring no other Oracle client networking hooks.

However this does not support connecting to Oracle database via Server Explorer in Visual Studio Express Edition.

Read this complete article for using the Managed Provider:

No comments: Protection Status