RE: ADO.NET or Enterprise Services (ES)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

1) ADO.NET Transactions: Good for local transactions to a single database

2) EntServices (COM+) Transactions: Good for distributed transactions, but
costly for local transactions. Plus the GAC, plus strong names, plus COM+
overhead.

--John Papa
http://codebetter.com/blogs/john.papa


"lottoman2000" wrote:

> I am debating which route to take for Declarative Trans
> Application. ADO.NET or ES (COM+). What do i gain by going
> the ADO.NET rounte and cetainly at what cost?
> Thank you
>
.

Relevant Pages

  • Re: Calling one EJB from another EJB
    ... > From your code the datasource/transaction used by PageEngine should ... PageEngine does not depends on anything. ... I dont understand the "Local Transactions" in this context. ...
    (comp.lang.java.programmer)
  • Re: When to use EJB?
    ... What are the most important things to consider when determining if EJB ... with other applications and their databases, use EJB - that's its job. ... affect one database only or the transactions do not span multiple databases, ... both available to participate in local transactions as well as distributed ...
    (comp.lang.java.programmer)
  • Overhead imposed by MSDTC
    ... is introduced by the use of Distributed Transactions? ... closing multiple connection objects for a single operation thanks to ... distributed even though we're going against SQL Server 2005. ...
    (microsoft.public.sqlserver)
  • Re: ADO.NET or Enterprise Services (ES)
    ... Even if you wanna do distributed transactions with ADO.NET in 1.1, ... still do them at the database level using linked servers, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: any ado.net experts please?
    ... If your transactions span entities more than ONE database, ... multiple classes enlist in COM+ distributed transactions. ... but i want my transaction object to persist across 3 data layer ...
    (microsoft.public.dotnet.framework.adonet)