| ee@ee.demon.co.uk 2006-04-30, 7:15 am |
| Hi
I am looking for an example that uses COM+ transaction (ServicedComponents)
services to control db updates with atomic transactions in BizTalk
If anyone has examples of Enterprise.ServicedComponents or/and with BizTalk
can you post a link.
Scenario example:
In this scenario I want to make two database changes and rollback them back
if something goes wrong. I do not wand to write compensations for the
actions I want to use ACID scope for the updates. This is simple using
something like DTS, i.e. it will automatically rollback on failure.
I want to be able to do then following:
Orchestration:
Receive PO
|
Expression Update SQL Via .Net Method call
|
Expression Update SQL Via another .Net Method call
|
Stop
I have a simple scenario where I want to call two separate .Net functions,
each of which update a row in a table.
Is there an example where two separate DB records are updated from within
two separate .Net component call from an orchestration with acid scope that
are then rolled back?
Thanks,
Jim
|