Transactions made easy: System.Transactions

re: Transactions made easy: System.Transactions

Sorin Dolha (MCSD .NET) — Fri, 23 Jul 2004 08:01:00 GMT

Very nice, I've been waiting for it for a long time! Good job!

Whidbey and transactions

Girish Bharadwaj — Fri, 23 Jul 2004 14:30:00 GMT

re: Transactions made easy: System.Transactions

Kyle Tinsley — Fri, 23 Jul 2004 12:05:00 GMT

This is awesome. Is TransactionScope also the way to handle single database (multi-table) transactions?

re: Transactions made easy: System.Transactions

Krishna — Fri, 23 Jul 2004 13:28:00 GMT

I tried out the code, the connection was against single SQL Server database but different tables, in code flow below, after Child Class 2 has set the TransactionConsistent option to false and calls a method in Child Class 3, if I put the code within a Transaction Scope, I get "Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction." if I don't put it in a Transaction Scope, I get "The transaction has already been implicitly or explicitly committed or aborted" If I set the TransactionConsitent bit to true, everything works fine..So how to handle these set of cases? I can send in the actual code in case you need them..

//Code flow

//Class 1
Using (TransactionScope1)
{
//Open Connection 1
//Create Child Class 1
}

//Child Class 1
Using (TransactionScope2)
{
//Open Connection 2
//User Code
//Set Transaction Consistent to false
//Create Child Class 2
}

//Child Class 2
{
//No Transaction Scope, just a read operation
//Open Connection <- Exception Thrown as "The transaction has already been implicitly or explicitly committed or aborted"

}

re: Transactions made easy: System.Transactions

Krishna — Fri, 23 Jul 2004 13:32:00 GMT

What about [Autocommit] and [TransactionOption] attributes similar to that of the support we have in EnterpriseServices. I remember seeing similar attributes in a presentation from the PDC on Distributed Transactions using the Light weight Transaction Manager.

We are currently using Remoting interception (derived from ContextBound and applied ContextAttributes) for Distributed Transactions without using EnterpriseServices. Since these classes are not documented and might become internal in future releases of the framework we want to move away from this model and use the System.Transaction classes instead, so we were comparing the options available and wanted to know if similar attributes would be made available in the future...basically we are looking for applying the "using TransctionScope" block through attributes and avoid having to write the plumbing code...

Thanks !

re: Transactions made easy: System.Transactions

Stuart — Fri, 23 Jul 2004 13:54:00 GMT

Simple transaction need that I can't figure out how to do it in 1.x *or* with new model:

I want transparent transactedness for all my ASP.NET pages. By which I mean, each page request should take place in its own transaction; if page load runs to completion with no exception (or terminates with the implicit ThreadAbortException thrown by Response.End, which is usually success in practice) the transaction is committed; otherwise (any other exception) it's rolled back. I'd also like to be able to access the transaction for rollback by hand, if there's an error condition that I want to handle some other way than by letting the exception propagate out.

I thought I could do that with a <%@ Page Transaction=something %> directive, but none of the available values of the Transaction attribute are, well, comprehensible to me at all. I tried a couple of the most likely-sounding candidates and ended up with the site completely screwed, giving an error even after I removed the transaction directive. I didn't try again after that; there are other developers working on the site too.

Even with the new transaction stuff described in your blog, I still can't figure out how I would implement this behavior. I can't use 'using' because there's nowhere to place the 'using' block such that its scope covers all of the page lifecycle. I'm sure I'm missing something obvious - like some documentation that makes sense? ;)

re: Transactions made easy: System.Transactions

Florin Lazar [MSFT] — Sat, 24 Jul 2004 02:15:00 GMT

TO: Kyle Tinsley
Yes, TransactionScope is also good for single-database transactions. In fact, when only one resource manager is used and this resource manager supports promotable transactions, there will be no overhead.

re: Transactions made easy: System.Transactions

Florin Lazar [MSFT] — Sat, 24 Jul 2004 02:34:00 GMT

To: Krishna

I have to see the code to give you an answer. You can send it to me by using the http://blogs.msdn.com/florinlazar/contact.aspx

One thing that you need to be careful is that it is not recommended to execute any code after you set the consistent flag inside a transaction scope. And in general, if you do set it to false, that means you are in a bad state and you want to abort everything as soon as possible, i.e. don't do any further work as part of that transaction because you know it will abort.

re: Transactions made easy: System.Transactions

Florin Lazar [MSFT] — Sat, 24 Jul 2004 02:43:00 GMT

To: Krishna 2nd comment

Currently there are no attributes for transactions as part of System.Transactions namespace. They are provided either by EnterpriseServices or will be by "Indigo" (these are the attributes you've seen at PDC). Or you can write your own attributes. Please, make sure to read my disclaimer.

re: Transactions made easy: System.Transactions

Florin Lazar [MSFT] — Sat, 24 Jul 2004 02:53:00 GMT

To: Stuart

Did you look at ContextUtil.SetAbort()? I believe this is what you are looking for.

See more info at http://samples.gotdotnet.com/quickstart/aspplus/doc/mtstransactions.aspx

Using distributed transactions in .Net 1.x without deriving from ServicedComponent

Florin Lazar's WebLog — Sat, 24 Jul 2004 11:49:00 GMT

Using distributed transactions in .Net 1.x without deriving from ServicedComponent

Florin Lazar's WebLog — Sat, 24 Jul 2004 21:57:00 GMT

re: Transactions made easy: System.Transactions

Krishna — Mon, 26 Jul 2004 14:20:00 GMT

Thanks Florin, I have submitted the code in the link provided..the subject is "System.Transactions Sample Code that throws Exception..See note on Blog" let me know if you need more information..

how to check the consistency of the transaction?..say a child class has set the transaction scope consistent flag to false..is it possible to check this in the parent class after the call to the child??..

on the note on Attributes..is there special attribute that we need to inherit from to make the transaction scopes transparent on a method or a class??

Thanks

re: using - It's not just for memory management

Eric Gunnerson's C# Compendium — Thu, 29 Jul 2004 11:21:00 GMT

System.Transactions in Whidbey

Kevin Cunningham's Blog — Fri, 05 Nov 2004 09:28:00 GMT

System.Transactions in Whidbey

Kevin Cunningham's Blog — Fri, 05 Nov 2004 20:44:00 GMT

Using distributed transactions in .Net 1.x without deriving from ServicedComponent

xdev — Wed, 05 Jan 2005 10:33:00 GMT

Ping Back来自：blog.csdn.net

Using distributed transactions in .Net 1.x without deriving from ServicedComponent

coollzh — Wed, 09 Mar 2005 18:45:00 GMT

TrackBack From:http://www.cnblogs.com/coollzh/archive/2005/03/09/115813.html

re: Transactions made easy: System.Transactions

Mike — Thu, 15 Sep 2005 18:24:57 GMT

Hey All,

Using Beta 2 of VS2005 and I'm attempting to use transaction scope in the business layer with no success. Seems to work ok on XP but when we run in a Windows 2003 environment, it fails with access denied.

Any ideas?
Mike

re: Transactions made easy: System.Transactions

florinlazar — Tue, 04 Oct 2005 07:21:24 GMT

To Mike: It's unusual to get an access denied. I don't know of any case when System.Transactions or DTC return "Access Denied". You should post more details about your scenario.

re: Transactions made easy: System.Transactions

hbzhang — Wed, 12 Oct 2005 10:55:39 GMT

When two connections opened in the same transactionscope, it triggers a DTC transaction, not a local transaction, even if two connections point to the same database. I use win2003 and sql2005 with .net 2.0 beta 2.

Is this behaviour as designed?

Thanks

re: Transactions made easy: System.Transactions

Jesús — Mon, 21 Nov 2005 12:25:05 GMT

I have the same trouble than Mike (see post on Thursday, September 15, 2005 11:24 AM) with the System.Transacions.

We are migrating code from Windows XP and VS2005 beta 2 to Windows Server 2003 and the VS2005 november release. We have the SQL Server in a different server and we are getting the exception message "The transaction has already been implicitly or explicitly committed or aborted".

The code is like this:

using (TransactionScope ts = new TransactionScope())
{
TableAdapter1 ta1 = new TableAdapter1();
TableAdapter2 ta2 = new TableAdapter2();
try
{
ta1.Update(dataset);
ta2.Update(dataset);
ts.Complete();
dataset.AcceptChanges();
return true;
}
catch
{
dataset.RejectChanges();
}
finally
{
ts.Dispose();
}
}

Thanks

re: Transactions made easy: System.Transactions

bogosian — Wed, 11 Jan 2006 19:23:33 GMT

for the TransactionScope - already committed/aborted one can read this very
useful article:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124293&SiteId=1

bye, good luck

re: Transactions made easy: System.Transactions

florinlazar — Tue, 31 Jan 2006 10:17:21 GMT

To: hbzhang

The behavior is currently by design. The WebData/ADO team may be able to optimize this in the future if we (me and you) ask them nicely :)

re: Transactions made easy: System.Transactions

florinlazar — Tue, 31 Jan 2006 10:24:09 GMT

To: Jesús

Shouldn't you put ts.Complete() after dataset.AcceptChanges? I'm not sure what AcceptChanges does, but if is trying to use the current transaction, that might explain why you are getting the exception.

re: Transactions made easy: System.Transactions

Ashish — Fri, 28 Apr 2006 10:29:13 GMT

To : Jesus, Why are u doing ts.Dispose? You are already using "using".

re: Transactions made easy: System.Transactions

BKimball — Tue, 02 May 2006 05:04:48 GMT

What version of Visual Studio 2005 is needed for the transactional support, or am I just really lost here? I put in using System.Transactions; (Well tried to, doesn't show up in intellisense) but am unable to access anything in the namespace. Was this dropped from the final release of VS2K5 or do I need something better than Standard Edition?

re: Transactions made easy: System.Transactions

Sundar Paranthaman — Thu, 20 Jul 2006 07:54:17 GMT

I am using TransactionScope object to achieve transaction support across 2 components that could have database interactions. Both components make connections to the database and change data. Even though both components connect to the same database with the same connection string, when the second connection is made the transaction escalates to a Distributed Transaction. Is it possible to change this behavior so that the transaction doesn’t escalate since the connections are to the same database with the same connection string. The main reason I want to prevent transaction escalation is our product has to work in WindowsXPSP2 and DTC service is disabled by default.

re: Transactions made easy: System.Transactions

David — Tue, 12 Sep 2006 09:25:36 GMT

I am geting Transaction aborted Execption, i am using sql Server 2000. using (TransactionScope scope = new TransactionScope() { Store_to_database(int vl,int v2) scope.Complete(); } In the Store_to_database function i am opening a connection to database, inserting the record. but i m geting Execption "The Transaction has Aborted" on connection.open() statement. please Help me.....

re: Transactions made easy: System.Transactions

florinlazar — Wed, 04 Oct 2006 04:17:18 GMT

To: Sundar Paranthaman

I recommend looking at the ConnectionScope class from

http://blogs.msdn.com/dataaccess/archive/2006/02/14/532026.aspx

re: Transactions made easy: System.Transactions

Dan — Wed, 21 Feb 2007 23:40:58 GMT

To use TransactionScope what needs to be installed and running on Windows 2000 or Windows 2003 server & SQL 2000?

Thanks.

re: Transactions made easy: System.Transactions

florinlazar — Thu, 22 Feb 2007 06:22:52 GMT

To: Dan

You need to install .Net Framework 2.0 or higher in order to be able to use System.Transactions.

re: Transactions made easy: System.Transactions

Khurram — Mon, 26 Feb 2007 18:14:31 GMT

Hi I am having the same error. In our case the application is on win server 2003 and the sql server on win2k. Do we need to install .NET framework 2 on both servers SQL and Web?

re: Transactions made easy: System.Transactions

florinlazar — Wed, 28 Feb 2007 22:29:16 GMT

I recommend posting your issues to http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=388&SiteID=1

Lexapro side effects.

Lexapro when does it work. — Sat, 19 Jul 2008 04:48:48 GMT

Lexapro. Side effects lexapro.

Propecia finasteride.

Propecia side effects bad. — Mon, 28 Jul 2008 07:52:06 GMT

Hair loss propecia drug dht. Propecia. Generic propecia. Propecia generic.