Oracle Data Providers (Connection Pooling & Transactions)

[Prits]

I want to connect to Oracle 8.1.7 server through my application. I would
like to know which .NET data provider will be the best option? Microsoft
Oracle Provider or a ODP.NET provided by Oracle.

Here server is hosting databases for many other applications and
performace is a big issue. So I want to choose a provider which will
give the best performance.

I also want to make use of connection pooling. Do I need to do some
specific setting for enabelling connection pooling using these
providers?

Also, do I need to use COM+ for supporting distributed transactions
while using any of the above 2 providers?

thanks in advance.

 

[Sahil Malik [MVP]]

Prits -

ODP.NET can do distributed transactions using Enterprise Services. I might
be wrong about it, but I don't think System.Data.OracleClient can (Just
write up a quick example and find out). Also, ODP.NET can do cool stuff like
SavePoints - which OracleClient cannot do.

BUT

Distributed Transactions using ES are a pain in the butt - are you sure you
need them? I mean, there are other ways to skin the same cat - what exactly
are you trying to acheive?

And Savepoints really can be done by direct execution of OracleCommand in
OracleClient - why not just stick with a wholly microsoft solution, and know
that it's done right? (I just feel nervous loaning the heart of my
application to Larry Ellison).

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/

 

[Sahil Malik [MVP]]

BTW forgot to mention - both should do conn.pooling.

Any decent self respecting .NET data provider should do connection pooling.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/

 

[Paul Clement]

¤ I want to connect to Oracle 8.1.7 server through my application. I would
¤ like to know which .NET data provider will be the best option? Microsoft
¤ Oracle Provider or a ODP.NET provided by Oracle.
¤
¤ Here server is hosting databases for many other applications and
¤ performace is a big issue. So I want to choose a provider which will
¤ give the best performance.
¤
¤ I also want to make use of connection pooling. Do I need to do some
¤ specific setting for enabelling connection pooling using these
¤ providers?
¤
¤ Also, do I need to use COM+ for supporting distributed transactions
¤ while using any of the above 2 providers?
¤

ODP.NET requires the 9i client or higher, so you will probably need to use the Microsoft .NET
Provider for Oracle instead if you're using 8.1.7.


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Sahil Malik [MVP]]

LOL Good point.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/