TransactionScop e using

[Aleksey Timonin]

Hi guys,
I tried to use TransactionScop e on to defferent TableAdapters like this:

using (TransactionSco pe transScope = new
TransactionScop e(TransactionSc opeOption.Requi red))
{
TableAdapter1.I nsertQuery(id, name);
TableAdapter2.I nsertQuery(id, customerName, customerAddress );
transScope.Comp lete();
}

It was failed because each table adapter using it's own connection and
TransactionScop e doesn't manage with it...
So I modified my code:

using (TransactionSco pe transScope = new
TransactionScop e(TransactionSc opeOption.Requi red))
{
SqlConnection conn = TableAdapter1.C onnection;

conn.Open();
TableAdapter1.I nsertQuery(id, name);
TableAdapter2.C onnection = conn;
TableAdapter2.I nsertQuery(id, customerName, customerAddress );
conn.Close();
transScope.Comp lete();
}
Am I using TransactionScop e correct? And if you see any problem in my code,
let me know.
Thanks a lot
Aleksey

[Nicholas Paldino [.NET/C# MVP]]

Aleskey,

What is the exception you are getting when you don't share the
connection? The connection ^should^ pick up on the ambient transaction and
enlist in it.

Then again, the provider might not even support it, but most providers
(from .NET 2.0 on, that is) should support it.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Aleksey Timonin" <al******@mdgme dical.comwrote in message
news:e2******** ******@TK2MSFTN GP05.phx.gbl...

Hi guys,
I tried to use TransactionScop e on to defferent TableAdapters like this:

using (TransactionSco pe transScope = new
TransactionScop e(TransactionSc opeOption.Requi red))
{
TableAdapter1.I nsertQuery(id, name);
TableAdapter2.I nsertQuery(id, customerName, customerAddress );
transScope.Comp lete();
}

It was failed because each table adapter using it's own connection and
TransactionScop e doesn't manage with it...
So I modified my code:

using (TransactionSco pe transScope = new
TransactionScop e(TransactionSc opeOption.Requi red))
{
SqlConnection conn = TableAdapter1.C onnection;

conn.Open();
TableAdapter1.I nsertQuery(id, name);
TableAdapter2.C onnection = conn;
TableAdapter2.I nsertQuery(id, customerName, customerAddress );
conn.Close();
transScope.Comp lete();
}
Am I using TransactionScop e correct? And if you see any problem in my
code, let me know.
Thanks a lot
Aleksey

[Aleksey Timonin]

The exception is:
Network access for Distributed Transaction Manager (MSDTC) has been
disabled.....
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c omwrote in
message news:ub******** ******@TK2MSFTN GP03.phx.gbl...

Aleskey,

What is the exception you are getting when you don't share the
connection? The connection ^should^ pick up on the ambient transaction
and enlist in it.

Then again, the provider might not even support it, but most providers
(from .NET 2.0 on, that is) should support it.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Aleksey Timonin" <al******@mdgme dical.comwrote in message
news:e2******** ******@TK2MSFTN GP05.phx.gbl...

>Hi guys,
I tried to use TransactionScop e on to defferent TableAdapters like this:

using (TransactionSco pe transScope = new
TransactionSco pe(TransactionS copeOption.Requ ired))
{
TableAdapter1. InsertQuery(id, name);
TableAdapter2. InsertQuery(id, customerName, customerAddress );
transScope.Com plete();
}

It was failed because each table adapter using it's own connection and
TransactionSco pe doesn't manage with it...
So I modified my code:

using (TransactionSco pe transScope = new
TransactionSco pe(TransactionS copeOption.Requ ired))
{
SqlConnectio n conn = TableAdapter1.C onnection;

conn.Open();
TableAdapter1. InsertQuery(id, name);
TableAdapter2. Connection = conn;
TableAdapter2. InsertQuery(id, customerName, customerAddress );
conn.Close() ;
transScope.Com plete();
}
Am I using TransactionScop e correct? And if you see any problem in my
code, let me know.
Thanks a lot
Aleksey

[Nicholas Paldino [.NET/C# MVP]]

Aleskey,

Have you configured DTC to allow distributed transactions across the
network? You need to go to Component Services (in the Administrative Tools
section) and then select the properties for your computer. You can then
configure the DTC on the MSDTC tab.

You also have to make sure that this is enabled on the other machine as
well, as it is participating in a distributed transaction.

Your code will allow you to get around the fact that it is a distributed
transaction by maintaining one connection, however, if you decide to compose
actions across different calls and want them to be included in the same
transaction, you would have to make your connection available to all of
those calls (which is a really bad idea). That's why it's a better idea to
enable the distributed transaction.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Aleksey Timonin" <al******@mdgme dical.comwrote in message
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..

The exception is:
Network access for Distributed Transaction Manager (MSDTC) has been
disabled.....
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c omwrote
in message news:ub******** ******@TK2MSFTN GP03.phx.gbl...

>Aleskey,

What is the exception you are getting when you don't share the
connection? The connection ^should^ pick up on the ambient transaction
and enlist in it.

Then again, the provider might not even support it, but most providers
(from .NET 2.0 on, that is) should support it.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Aleksey Timonin" <al******@mdgme dical.comwrote in message
news:e2******* *******@TK2MSFT NGP05.phx.gbl.. .

>>Hi guys,
I tried to use TransactionScop e on to defferent TableAdapters like this:

using (TransactionSco pe transScope = new
TransactionSc ope(Transaction ScopeOption.Req uired))
{
TableAdapter1 .InsertQuery(id , name);
TableAdapter2 .InsertQuery(id , customerName, customerAddress );
transScope.Co mplete();
}

It was failed because each table adapter using it's own connection and
TransactionSc ope doesn't manage with it...
So I modified my code:

using (TransactionSco pe transScope = new
TransactionSc ope(Transaction ScopeOption.Req uired))
{
SqlConnecti on conn = TableAdapter1.C onnection;

conn.Open() ;
TableAdapter1 .InsertQuery(id , name);
TableAdapter2 .Connection = conn;
TableAdapter2 .InsertQuery(id , customerName, customerAddress );
conn.Close( );
transScope.Co mplete();
}
Am I using TransactionScop e correct? And if you see any problem in my
code, let me know.
Thanks a lot
Aleksey