Welcome to MSDN Blogs Sign in | Join | Help

May 2008 - Posts

Thursday, May 08, 2008 3:21 PM

When not to use transactions and where you can't use transactions

Transactions are great when everyone plays in. You group a set of activities together under a transaction and you start executing them. If anything bad happens along the way or something doesn't go as planned, invoke rollback and all is taking care of
Posted by florinlazar | 1 Comments
Wednesday, May 07, 2008 3:01 PM

MSDTC and COM+ Configuration Tool in Vista

To access the MSDTC and COM+ configuration tool in Windows Vista, also known as Component Services MMC, you have the following options: 1. Run “dcomcnfg” 2. Or run: %SystemRoot%\System32\comexp.msc 3. Or if you prefer, you can add a shortcut to %SystemRoot%\System32\comexp.msc
Posted by florinlazar | 0 Comments
Filed under:
Tuesday, May 06, 2008 11:58 PM

Exception Handling without catch(Exception)

The design guidelines for exception handling are quite clear on avoiding “catch all” and/or avoiding catching exceptions you can’t handle. But there are cases when you really need to know if the try block completed successfully or not, and possibly take
Posted by florinlazar | 2 Comments
Filed under:
Tuesday, May 06, 2008 12:54 PM

Working with CMD and Long Path Names

I like using the command prompt for a lot of things and working with long (or very long) path names is something that is common these days. Fortunately, you can customize cmd by using "prompt". Do a “prompt /?” in a command window to see all the options.
Posted by florinlazar | 0 Comments
Filed under:
Monday, May 05, 2008 3:04 AM

How to Use System.Data with System.Transactions and Maintain Atomicity and Data Consistency

The Bug I call it a bug. Initially I was persuaded to believe it was a feature; later I was "convinced" that it is now a matter of app compat and it can't be changed anymore. Let’s look at the following code: SqlConnection connection1 = new SqlConnection(connectionString);
Posted by florinlazar | 4 Comments
Monday, May 05, 2008 1:38 AM

Limitation of TransactionScope (and using)

If you read the documentation for TransactionScope , you will find: "If no exception occurs within the transaction scope […], then the transaction in which the scope participates is allowed to proceed. If an exception does occur within the transaction
Posted by florinlazar | 0 Comments
Filed under: ,
Friday, May 02, 2008 4:02 PM

Avoiding Transaction Promotion with Multiple Connections - Improvements in System.Data and SQL Server 2008

Great news! The new updates added to System.Data and SQL Server 2008 finally allow multiple Open/Close connections to the same SQL Server without promoting the transaction to MSDTC. This was by far the most requested feature for the System.Transactions/System.Data/SQL
Posted by florinlazar | 2 Comments
 
Page view tracker