Attention: We are retiring the ASP.NET Community Blogs. Learn more >

System.Transactions

If you are in an existing transaction and within a Sql CLR Object, when you create a connection to a remote server, you will automagically be promoted to a distributed transaction and use the System.Transactions namespace.  if you don't open a connection to a remote server, a distributed transaction is not created and you don't need to worry about its overhead.  Much sweeter than the COM+ way of you either get a distributed transaction whether you need it or not.

Wally

1 Comment

  • There was a way to write code in Enterprise Services and old COM+ to do the same thing "automagically", but did require a little more effort. It is nice that they are making this more seamless.

Comments have been disabled for this content.