ADO.NET 2.0 and System.Transactions, downlevel functions and nested scopes

As with most of my blog posts this started as a customer question, the core of the problem was that he was not sure how he was expected to use TransactionScopes in methods that call other methods or “downlevel” functions as he named them. There are two important concepts to keep in mind. 1) downlevel…

5

ado.net 2.0 changes in latest community drop.

Well, it has been a long time since my last blog and it is going to be a while before I get going again. Whenever this happens you can count on me being either insanely behind or on vacation.   I am happy to report that the insanely behind part is over. The ado.net team…

13

ADO.NET 2.0 The connection pool and distributed transactions

I am a big fan of pop quiz style blogs like the ones you can find here: http://blogs.msdn.com/brada/ . I am not really sure that there are enough people looking at this blog to make this fun but I am going to give it a try. I will incorporate the answer in the blog at…

2

Setting the IsolationLevel using the System.Transactions TransactionScope.

Traditionally distributed transactions have always run in Serializable isolation level, the safest but most expensive transaction isolation level where everything that we look at is locked from the moment we modify something and until the distributed transaction completes. This is very expensive and most of the time it is not necessary, fortunately we are no…

2

ADO.NET Distributed transactions, loose ends.

There is still a lot of information related to using ADO.NET with System.Transactions Distributed Transactions, but in the interest of keeping the blog moving I am going to roll up most of the issues into this final post. Feel free to post questions if anything does not make too much sense.   Random ramblings: The…

5

Whidbey ADO.NET Promotable Transactions with System.Transactions & Yukon

There is a special partnership between System.Transactions and Sql Server 2005, and no, it is not the fact that we begged the Enterprise Services team to ship this feature on whidbey and it is not (only) the fact that this is the only way to get distributed transactions to work inproc in Yukon (will talk…

23

Whidbey ado.net 2.0 Manually enlisting into System.Transaction distributed transaction.

I have gone over the TransactionScope in fair detail, it is now time to look at manual enlistment, the second way to use System.Transactions Distributed Transactions with ADO.NET. Unlike the TransactionScope example wich was complete and bullet proof this is neither. Here we still need to specify the logic for rolling back the transaction and…

0

More setup information, straight from the source

Florin Lazar was the person that first introduced me to System.Transactions, he has a great weblog here: http://blogs.msdn.com/florinlazar/ That is full of information on how to set up your computer to use distributed transactions and really great links to what you can expect from System.Transactions in the future.

3

Whidbey ADO.NET 2.0 System.Transactions Distributed Transactions. TransactionScope

Let’s take a look at how the new System.Transactions Distributed Transactions work with ADO.NET 2.0. I am going to start with the best and easiest way to use distributed transactions in managed code, the TransactionScope. The following code is (or should be) bullet proof, without even realizing it you have bypassed most of the hidden…

15

Whidbey ADO.NET System.Transactions Distributed Transactions

This is imo one of the best new features for ADO.NET imo and I was glad to get some feedback that expressed interest. I will blog on this feature for the rest of the week, here is how to get started.   The hardest thing about this feature is without a doubt the OS setup…

15