Posted Thursday May 8, 2008, 9:11 am, Over one day old
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...(read more)
Read When not to use transactions and where you can't use transactions (Links)
Posted Wednesday May 7, 2008, 10:03 am, Over one day old
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%System32comexp.msc 3. Or if you prefer, you can add a shortcut to %SystemRoot%System32comexp.msc...(read more)
Read MSDTC and COM+ Configuration Tool in Vista (Links)
Posted Wednesday May 7, 2008, 10:03 am, Over one day old
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...(read more)
Read Exception Handling without catch(Exception) (Links)
Posted Tuesday May 6, 2008, 12:47 pm, Over one day old
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....(read more)
Read Working with CMD and Long Path Names (Links)
Posted Monday May 5, 2008, 10:47 am, Over one day old
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);...(read more)
Read How to Use System.Data with System.Transactions and Maintain Atomicity and Data Consistency (Links)
Posted Monday May 5, 2008, 10:47 am, Over one day old
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...(read more)
Read Limitation of TransactionScope (and using) (Links)
Posted Friday May 2, 2008, 11:39 am, Over one day old
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...(read more)
Read Big Improvements in System.Data and SQL Server for Lightweight Transaction Support (Links)
Posted Monday March 24, 2008, 10:43 am, Over one day old
In .Net 3.5 I can write a transactional code block as follows: transacted(()=> { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command1 = new SqlCommand(commandString1, connection); command1.ExecuteNonQuery();...(read more)
Read A Simpler TransactionScope (Links)
Posted Saturday January 26, 2008, 1:27 pm, Over one day old
Read TIP is now deprecated (Links)