.NET with Oracle 8.1.7

  • Thread starter Thread starter Terry Diederich
  • Start date Start date
T

Terry Diederich

I'm going to be starting an ASP.NET (VS 2003 and Framework
v1.1)project soon that will be accessing an Oracle 8.1.7
database. This will be the first time I've used Oracle with
..NET, everything else has been using SQL Server. I was
wondering which access method is working best with this version
of Oracle, the .NET Managed provider or the OLEDB Provider.

Thanks.
 
Terry Diederich said:
I'm going to be starting an ASP.NET (VS 2003 and Framework
v1.1)project soon that will be accessing an Oracle 8.1.7
database. This will be the first time I've used Oracle with
.NET, everything else has been using SQL Server. I was
wondering which access method is working best with this version
of Oracle, the .NET Managed provider or the OLEDB Provider.
Click to expand...

I would recommend against using the OleDB provider. You introduce another
protocol layer (oleDb)
and another technology layer (COM interop).

Use the .NET Managed provider from Microsoft or the Oracle Data Provider for
DotNet from Oracle.

ODP.NET from oracle needs to be installed seperately, but it comes bundeled
with the Oracle Client, which you need to install anyway, so it's really a
wash.

Both have the same architecture: managed code wrapping OCI through P/Invoke.

ODP.NET exposes more Oracle functionality (surprise), like LOB's, Array
Binding, PL/SQL Tables, XML, and is supported by Oracle (just post any
problems to the ODP.NET forum at OTN.ORACLE.COM ).

But the Microsoft driver can run ordinary SQL and PL/SQL, hit stored
procedures and handle ref cursors.

David
 
Back
Top