Pass transaction between classes

[Ofir Amitai]

Hi all,

I'm trying to pass a transaction between several classes.
I pass the connection & the transaction through all the classes I need and
all the updated are done.
My problem is when I try to do a Commit. I get the following error:

"This SqlTransaction has completed; it is no longer usable."

what a I doing wrong?

Thanks,
Ofir

 

[Leigh Kendall]

You might be better off using COM+/Service Components; the programming model
is much simpler, especially when the transaction is more involved, including
passing transaction contexts across classes.

Here's some good info to get started:
http://www.gotdotnet.com/team/xmlentsvcs/

HTH,

 

[Gavin Joyce]

Hi,

Have a look at this post -
http://www.gavinjoyce.com/forums/ShowPost.aspx?PostID=228

Thanks.
Gavin Joyce

===================================
nTierGen.NET Framework Generator 1.3
http://www.nTierGen.NET/

Generates Stored Procedures, Data Access Code, Business Rules Layer,
Stongly-Typed DataSets, Web Services
===================================

 

[Leigh Kendall]

Subtle plug...

Hi,

Have a look at this post -
http://www.gavinjoyce.com/forums/ShowPost.aspx?PostID=228

Thanks.
Gavin Joyce

===================================
nTierGen.NET Framework Generator 1.3
http://www.nTierGen.NET/

Generates Stored Procedures, Data Access Code, Business Rules Layer,
Stongly-Typed DataSets, Web Services
===================================

 

[Gavin Joyce]

Hi,

Have a look at this post -
http://www.gavinjoyce.com/forums/ShowPost.aspx?PostID=228

Thanks.
Gavin

--
___________________________________________________________
nTierGen.NET Code Generator - http://www.nTierGen.NET/

Stored Procedures (Get, GetPaged, Insert, Update, Delete)
Data Access Layer - C#
Business Rules Layer - C# & VB.NET
Strongly-Typed DataSets - C#
Web Services - C#
___________________________________________________________

 

[devnet]

PureObjects

PureObjects is a web based code generator that builds several major portions of a .NET application including the database access layer, stored procedures, business, and model layers for C# and VB.NET
http://www.pureobjects.com