Oracle

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/details.aspx?FamilyID=4f55d429-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
Mon Nov 20 06:45:32 CST 2006


"Bragadiru" <adi_lazar@nospam.nospam> wrote in message
news:e$Yg9CJDHHA.2176@TK2MSFTNGP04.phx.gbl...
> 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/details.aspx?FamilyID=4f55d429-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.

v-wywang
Mon Nov 20 22:40:35 CST 2006

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

MrSmersh
Tue Nov 21 04:31:01 CST 2006

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.


"WenYuan Wang" wrote:

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

Bragadiru
Fri Nov 24 04:19:52 CST 2006

Thanks a lot

I'll start with Oracle provider, not Ms.

"Bragadiru" <adi_lazar@nospam.nospam> wrote in message
news:e$Yg9CJDHHA.2176@TK2MSFTNGP04.phx.gbl...
> 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/details.aspx?FamilyID=4f55d429-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
>
>
>