Oracle

[Bragadiru]

Hi,

My app needs support for Oracle 10 g database : reading (select ...) +
updating + calling stored procedures + distributed transactions eventually.
I built it in VS 2005 (ado.net 2.0).

What should I use ? Microsoft Oracle .NET Managed provider or Oracle Data
Provider for .NET 2.0 ?
I want to know the limitations of each one, tricky pbs, licensing. Microsoft
did release a new Oracle.NET for .NET 2.0 ?? I found only the version 1.0
(http://www.microsoft.com/downloads/...29-17dc-45ea-bfb3-076d1c052524&DisplayLang=en).

Does anyone know if I can use promotable transactions (TransactionScope)
when working with Oracle 10g ?

Thanks for any advice

 

[pvdg42]

Hi,

My app needs support for Oracle 10 g database : reading (select ...) +
updating + calling stored procedures + distributed transactions
eventually. I built it in VS 2005 (ado.net 2.0).

What should I use ? Microsoft Oracle .NET Managed provider or Oracle Data
Provider for .NET 2.0 ?
I want to know the limitations of each one, tricky pbs, licensing.
Microsoft did release a new Oracle.NET for .NET 2.0 ?? I found only the
version 1.0
(http://www.microsoft.com/downloads/...29-17dc-45ea-bfb3-076d1c052524&DisplayLang=en).

Does anyone know if I can use promotable transactions (TransactionScope)
when working with Oracle 10g ?

Thanks for any advice

In the case of Oracle, or other "foreign" databases, you should use the
technology provided by the database vendor. It's the database vendor who has
the strongest vested interest in providing the best and most up-to-date
support for their product to all developers.

 

[WenYuan Wang]

Hi

Microsoft has released .NET Managed Provider for Oracle 2.0.
But it has been included in .Net framework 2.0. So we don't have to
download it from the Microsoft website.

We can find it in GAC.
In <% windows %> \assembly directory, there is an assembly named
"System.Data.OracleClient". We can found the version of this assembly is
2.0.0.0.

But I also agree with our community member. In order to get the most
performance, we suggest you can use Oracle Data Provider for .NET. (
http://www.oracle.com/technology/tech/windows/odpnet/index.html)
ODP.NET makes using Oracle from .NET more flexible, faster, and more stable.

If there is anything unclear, please feel free to contact me.
Sincerely,
WenYuan

 

[Guest]

Use the Oracle is my advice also.
If you plan later to switch them be careful that the drivers treat
differently some of the fields, for example a getInt on a field using the
native provider could work but using the other could fail with a cast
exception error.

 

[Bragadiru]

Thanks a lot

I'll start with Oracle provider, not Ms.