Oracle


B

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

Advertisements

P

pvdg42

Bragadiru said:
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.
 
W

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
 
G

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oracle 3
Oracle.... 1
ORACLE 3
Oracle 6
Oracle DataReader 8
Oracle Tables 1
Oracle Function 2
SqlBulkCopy and Oracle? 5

Top