Re: Oracle




"Bragadiru" <adi_lazar@xxxxxxxxxxxxx> wrote in message
news:e$Yg9CJDHHA.2176@xxxxxxxxxxxxxxxxxxxxxxx
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.


.



Relevant Pages

  • Oracle
    ... updating + calling stored procedures + distributed transactions eventually. ... Microsoft Oracle .NET Managed provider or Oracle Data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle
    ... Microsoft Oracle .NET Managed provider or Oracle Data ... Does anyone know if I can use promotable transactions ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Is Interbase still thriving?
    ... when faced with MSSQL and wether to adapt ... In Oracle/IB/Progress you have much less contention problems derived ... Oracle DB. ... It´s very important that you design your transactions to ...
    (borland.public.delphi.non-technical)
  • Re: AutoCommit - Oracle.
    ... > and invoked the stored procedures, the user would not have to worry about ... Oracle never autocommits. ... are only internal should not be used to control transactions. ...
    (microsoft.public.dotnet.framework.adonet)
  • HP tops 1 million tpmC on Superdome with Itanium2 CPUs
    ... HP and Oracle Set World Record Performance Mark -- First to Top 1 ... Million Transactions per Minute ... Superdome server and IntelŪ ItaniumŪ 2 processors. ...
    (comp.os.vms)