Transactions across components

[RJN]

Hi

I have a transaction requirement that spawns across components. Typical
example is saving address, order etc. Each of these components will do
their part of transaction. If any of the transactions failed, then all
the transactions have to be rolled back. One way is to go for COM+
transaction using ServicedComponent. But this affects performance and
moreover we have no across database transactions. Another way I found is
to use ServiceConfig class (http://www.15seconds.com/issue/030930.htm).
But this requires Windows 2003 server. Is there any other way to do
this?

Thanks

rjn

 

[Marina]

Use ADO transaction. Place the connection/transaction in a place all
components can access it, and have them use it. Be sure you are
committing/rolling back the transaction and closing the connection when the
whole call stream is done.