Hi all,
I built my ASP.NET application making use of the ThePhile data- and 
business- tier "framework".
IMHO the ThePhile data tier supports transactions only partially! 
I need transactions over several data tier calls. E.g. from within the 
business tier I create several (persistent) objects and I would like the 
creation of all these objects to be atomic. This is impossible though, 
because on any data tier call (stored procedure) the db connection is 
opened and then closed again.
Do I have to make use of the COM+ Transactions?
Any other suggestions?
Can/should I try to bind a db connection to a Session or Request?

Regards
Clemens

Take a look at what ADO.NET offers in the transaction arena as well, this 
link provides some documentation on the IDbTransaction that is (quote) 
"Implemented by .NET data providers that access relational databases"...  A 
simple and yet powerful way of providing transactional support within your 
application.

<link description="IDbTransaction Interface" note="Watch for wrapping">
http://msdn.microsoft.com/library/?url=/library/en-us/cpref/html/frlrfSystemDataIDbTransactionClassTopic.asp?frame=true
</link>

hth,
Al






>From: "Clemens" <clemens.wyss@h...>
>Reply-To: "ASP.NET" <aspx@p...>
>To: "ASP.NET" <aspx@p...>
>Subject: [aspx] "Highlevel" transactions
>Date: Tue, 12 Nov 2002 10:26:39
>
>Hi all,
>I built my ASP.NET application making use of the ThePhile data- and
>business- tier "framework".
>IMHO the ThePhile data tier supports transactions only partially!
>I need transactions over several data tier calls. E.g. from within the
>business tier I create several (persistent) objects and I would like the
>creation of all these objects to be atomic. This is impossible though,
>because on any data tier call (stored procedure) the db connection is
>opened and then closed again.
>Do I have to make use of the COM+ Transactions?
>Any other suggestions?
>Can/should I try to bind a db connection to a Session or Request?
>
>Regards
>Clemens


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail