TransactionScop e in framework 2.0

[Mukesh]

Hi,

I am new to 2.0 framework. I am trying to use TransactionScop e in the
following code. I took four lables. Started TransactionScop e scope.
After setting values to three labels I throw an exception. I expexted
all label value would remain as method Complete() of TransactionScop e
scope was not complete. But actually three labels are showing new
values.

label1.Text="1" ;
label2.Text="1" ;
label3.Text="1" ;
label4.Text="1" ;
private void Change_Label()
{
using (TransactionSco pe scope = new TransactionScop e())
{
Exception ee = new Exception("My Exception");
try
{
label1.Text = "0";
label2.Text = "0";
label3.Text = "0";
throw ee;
label4.Text = "0";
scope.Complete( );
}
catch (Exception ex)
{
MessageBox.Show ("Transactio n not completed");
}
}
}

Can't we use TransactionScop e in these situations? Is there alternate
solution? What if instead of statements, few methods were called each
operationg on different rows. Suppose I have three different method
m1(); m2(); m3() and insert one row each in table t1,t2 and t3
respectively. In a sample run after execution of m1() and m2() an
Exception occured. Would it mean no new row in t3 as well as t1 and
t2.

Thanks
Mukesh

[Kalpesh]

Mukesh,

AFAIK, TransactionScop e is related to Database Transactions & not
memory transactions

Kalpesh

[Mukesh]

Hi Kalpesh,

Still the second part of the question is vaild where different methods
are updating tables. What are your ideas on it?

Regards,
Mukesh

[Michael Nemtsev]

AFAIK, when you include your objects in transaction scope CLR tries to enlist
these objects into TRM (transaction resource manager), in other words trying
to get info about what to do if your commit/abort transaction.

In your case, you use variables/functions that are not controlled by
TransactrionMan agers (and there is no way to make them controlled), and in
the result you change you object directly.

This is well-known problem since 1997, where COM+ and Transactions firstly
come to our word. For this reason you need to use "Compensato rs". It's a way
to watch on you object that are used in transaction and in case of abort -
restore initial value. This idea used wide in COM+ world.
Another case, natural but forthcoming, is STM - Software Transaction Memmory
(googling to get more info). Microsoft have been working on this notion for
the last 3 years, but I'm not sure whether they have any samples.

Hi Kalpesh,

Still the second part of the question is vaild where different methods
are updating tables. What are your ideas on it?

--
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[Mukesh]

To test TransactionScop e behaviour I created four table t1, t2, t3,t4
wil only one column sl. Four method m1, m2, m3 and m4 insert one row
to these tables respectively. These methods are independent otherwise.
There is a method Call_Methods() which will call m1, m2, m3 and m4
within transaction scope. m1 get executed. I checked this table from
Query analyzer. The row was locked. After calling m3 exception is
thrown and as exception handler TransactionScop e is disposed. To my
surprise no changes was done to any tables. It means TransactionScop e
automatically started transaction in each method. How it happened?
What if m2 uses m1 updated values?

private void Call_Methods()
{
using (TransactionSco pe scope = new TransactionScop e())
{
Exception ee = new Exception("Muke sh created
exception");
try
{
m1();
m2();
m3();
throw ee;
m4();
scope.Complete( );
}
catch (Exception ex)
{
MessageBox.Show ("Exception Occured" + ex.Message);
scope.Dispose() ;
}
}
}
private void m1()
{
string conStr = "Persist Security Info=False;User
ID=sa;Password= 931;Initial Catalog= mukesh; Data
Source=10.26.5. 125\\LOCAL_MUKE SH";
SqlConnection cn;
cn = new SqlConnection(c onStr);
cn.Open();
SqlCommand cmd = new SqlCommand("Ins ert into t1 values(1)",
cn);
cmd.ExecuteNonQ uery();
cn.Close();

}
private void m2()
{
string conStr = "Persist Security Info=False;User
ID=sa;Password= 931;Initial Catalog= mukesh; Data
Source=10.26.5. 125\\LOCAL_MUKE SH";
SqlConnection cn;
cn = new SqlConnection(c onStr);
cn.Open();
SqlCommand cmd = new SqlCommand("Ins ert into t2 values(2)",
cn);
cmd.ExecuteNonQ uery();
cn.Close();

}
private void m3()
{
string conStr = "Persist Security Info=False;User
ID=sa;Password= 931;Initial Catalog= mukesh; Data
Source=10.26.5. 125\\LOCAL_MUKE SH";
SqlConnection cn;
cn = new SqlConnection(c onStr);
cn.Open();
SqlCommand cmd = new SqlCommand("Ins ert into t3 values(3)",
cn);
cmd.ExecuteNonQ uery();
cn.Close();
}
private void m4()
{
string conStr = "Persist Security Info=False;User
ID=sa;Password= 931;Initial Catalog= mukesh; Data
Source=10.26.5. 125\\LOCAL_MUKE SH";
SqlConnection cn;
cn = new SqlConnection(c onStr);
cn.Open();
SqlCommand cmd = new SqlCommand("Ins ert into t4 values(4)",
cn);
cmd.ExecuteNonQ uery();
cn.Close();
}

Thanks
Mukesh

[Michael Nemtsev]

Hello Mukesh,

It's because you methods use SqlConnection that can be enlisted in Transaction
Manager

I recomend to read this article http://www.microsoft.com/downloads/d...displaylang=en
in the beginning Juwal open this subject

M> To test TransactionScop e behaviour I created four table t1, t2, t3,t4
M> wil only one column sl. Four method m1, m2, m3 and m4 insert one row
M> to these tables respectively. These methods are independent
M> otherwise.
M> There is a method Call_Methods() which will call m1, m2, m3 and m4
M> within transaction scope. m1 get executed. I checked this table
M> from
M> Query analyzer. The row was locked. After calling m3 exception is
M> thrown and as exception handler TransactionScop e is disposed. To my
M> surprise no changes was done to any tables. It means
M> TransactionScop e automatically started transaction in each method.
M> How it happened? What if m2 uses m1 updated values?
M>
M> private void Call_Methods()
M> {
M> using (TransactionSco pe scope = new TransactionScop e())
M> {
M> Exception ee = new Exception("Muke sh created
M> exception");
M> try
M> {
M> m1();
M> m2();
M> m3();
M> throw ee;
M> m4();
M> scope.Complete( );
M> }
M> catch (Exception ex)
M> {
M> MessageBox.Show ("Exception Occured" +
M> ex.Message);
M> scope.Dispose() ;
M> }
M> }
M> }
M> private void m1()
M> {
M> string conStr = "Persist Security Info=False;User
M> ID=sa;Password= 931;Initial Catalog= mukesh; Data
M> Source=10.26.5. 125\\LOCAL_MUKE SH";
M> SqlConnection cn;
M> cn = new SqlConnection(c onStr);
M> cn.Open();
M> SqlCommand cmd = new SqlCommand("Ins ert into t1
M> values(1)",
M> cn);
M> cmd.ExecuteNonQ uery();
M> cn.Close();
M> }
M> private void m2()
M> {
M> string conStr = "Persist Security Info=False;User
M> ID=sa;Password= 931;Initial Catalog= mukesh; Data
M> Source=10.26.5. 125\\LOCAL_MUKE SH";
M> SqlConnection cn;
M> cn = new SqlConnection(c onStr);
M> cn.Open();
M> SqlCommand cmd = new SqlCommand("Ins ert into t2
M> values(2)",
M> cn);
M> cmd.ExecuteNonQ uery();
M> cn.Close();
M> }
M> private void m3()
M> {
M> string conStr = "Persist Security Info=False;User
M> ID=sa;Password= 931;Initial Catalog= mukesh; Data
M> Source=10.26.5. 125\\LOCAL_MUKE SH";
M> SqlConnection cn;
M> cn = new SqlConnection(c onStr);
M> cn.Open();
M> SqlCommand cmd = new SqlCommand("Ins ert into t3
M> values(3)",
M> cn);
M> cmd.ExecuteNonQ uery();
M> cn.Close();
M> }
M> private void m4()
M> {
M> string conStr = "Persist Security Info=False;User
M> ID=sa;Password= 931;Initial Catalog= mukesh; Data
M> Source=10.26.5. 125\\LOCAL_MUKE SH";
M> SqlConnection cn;
M> cn = new SqlConnection(c onStr);
M> cn.Open();
M> SqlCommand cmd = new SqlCommand("Ins ert into t4
M> values(4)",
M> cn);
M> cmd.ExecuteNonQ uery();
M> cn.Close();
M> }
M> Thanks
M> Mukesh
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[Mukesh]

Hi,
The article is really very useful. Thanks a lot.

Mukesh

Michael Nemtsev wrote:

Hello Mukesh,

It's because you methods use SqlConnection that can be enlisted in Transaction
Manager

I recomend to read this article http://www.microsoft.com/downloads/d...displaylang=en
in the beginning Juwal open this subject

M> To test TransactionScop e behaviour I created four table t1, t2, t3,t4
M> wil only one column sl. Four method m1, m2, m3 and m4 insert one row
M> to these tables respectively. These methods are independent
M> otherwise.
M> There is a method Call_Methods() which will call m1, m2, m3 and m4
M> within transaction scope. m1 get executed. I checked this table
M> from
M> Query analyzer. The row was locked. After calling m3 exception is
M> thrown and as exception handler TransactionScop e is disposed. To my
M> surprise no changes was done to any tables. It means
M> TransactionScop e automatically started transaction in each method.
M> How it happened? What if m2 uses m1 updated values?
M>
M> private void Call_Methods()
M> {
M> using (TransactionSco pe scope = new TransactionScop e())
M> {
M> Exception ee = new Exception("Muke sh created
M> exception");
M> try
M> {
M> m1();
M> m2();
M> m3();
M> throw ee;
M> m4();
M> scope.Complete( );
M> }
M> catch (Exception ex)
M> {
M> MessageBox.Show ("Exception Occured" +
M> ex.Message);
M> scope.Dispose() ;
M> }
M> }
M> }
M> private void m1()
M> {
M> string conStr = "Persist Security Info=False;User
M> ID=sa;Password= 931;Initial Catalog= mukesh; Data
M> Source=10.26.5. 125\\LOCAL_MUKE SH";
M> SqlConnection cn;
M> cn = new SqlConnection(c onStr);
M> cn.Open();
M> SqlCommand cmd = new SqlCommand("Ins ert into t1
M> values(1)",
M> cn);
M> cmd.ExecuteNonQ uery();
M> cn.Close();
M> }
M> private void m2()
M> {
M> string conStr = "Persist Security Info=False;User
M> ID=sa;Password= 931;Initial Catalog= mukesh; Data
M> Source=10.26.5. 125\\LOCAL_MUKE SH";
M> SqlConnection cn;
M> cn = new SqlConnection(c onStr);
M> cn.Open();
M> SqlCommand cmd = new SqlCommand("Ins ert into t2
M> values(2)",
M> cn);
M> cmd.ExecuteNonQ uery();
M> cn.Close();
M> }
M> private void m3()
M> {
M> string conStr = "Persist Security Info=False;User
M> ID=sa;Password= 931;Initial Catalog= mukesh; Data
M> Source=10.26.5. 125\\LOCAL_MUKE SH";
M> SqlConnection cn;
M> cn = new SqlConnection(c onStr);
M> cn.Open();
M> SqlCommand cmd = new SqlCommand("Ins ert into t3
M> values(3)",
M> cn);
M> cmd.ExecuteNonQ uery();
M> cn.Close();
M> }
M> private void m4()
M> {
M> string conStr = "Persist Security Info=False;User
M> ID=sa;Password= 931;Initial Catalog= mukesh; Data
M> Source=10.26.5. 125\\LOCAL_MUKE SH";
M> SqlConnection cn;
M> cn = new SqlConnection(c onStr);
M> cn.Open();
M> SqlCommand cmd = new SqlCommand("Ins ert into t4
M> values(4)",
M> cn);
M> cmd.ExecuteNonQ uery();
M> cn.Close();
M> }
M> Thanks
M> Mukesh
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche