Transactions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a C# method that performs the following types of transactions
- DB transaction
- DB transactions via another componen
- non DB transactions such as file creation, ftp and emai

How can I wrap all these into one transaction with rollback capabilities?
 
Hi Alex,

You can't. How would you rollback ftp or e-mail?
You might use COM+ that has a concept of handling many different
transactions under one, but still, I can't see a transaction with ftp and
e-mail. Plus, I would say that you won't be able to control component
transaction.
 
Hey Alex

COM+ supports something called Compensating Ressource Managers (CRM). You can write your own CRM by supporting a number of COM interfaces which enables you to e.g. send e-mails within a distributed transaction. With CRMs you do not get all four ACID properties (as far as I remember you only get A, C, and I - it's been a long time since I wrote my last CRM). This article should get you started: http://msdn.microsoft.com/msdnmag/issues/01/03/crm/default.asp

Regards, Jakob.
 
Back
Top