Geek Answers Handbook

TransactionScope and Long-Term Resources

Quick question about a TransactionScope object. This is discovered on the Internet:

When you go to your first long-term resource manager, a lightweight transactional transaction is created to support a single transaction. When you access the second trusted resource manager, the transaction advances to a distributed transaction.

It seems beautiful, but I did not understand what a "durable resource" is. I know that TransactionScope only works with SQL Server 2005 and above, so if I need to access SQL Server 200, will it be impossible? How about a text file on disk? I have always heard that you cannot manage transactions when it comes to disk access. Maybe this is different from this object?

Thank!

+5
source share
2 answers

This link discusses the differences between trusted and fragile resource managers.

Just to clarify - TransactionScopes will work with earlier versions of SQL , but the easy transaction manager only works with 2005+. SQL 2000 transactions require a DTC.

There is also support for transactional file systems (Vista and later) - see here .

+5
source

Resource managers have two types

  • : . . , . . SQL Server MSMQ.
  • : , . .Net.
+2

More articles:


All Articles