SqlTransaction.Commit

Thanks!

This application uses a DAL that hides the connection from
the
developer, so that might explain why the connection was
never being
closed.

Bob
 

-----Original Message-----
From: Discussion of building .NET applications targeted for
the Web
[mailtoOTNET-WE
BDISCUSS.DEVELOP.COM] On Behalf Of Ivanoff, Alex
Sent: Tuesday, April 11, 2006 10:01 AM
To: DOTNET-WEBDISCUSS.DEVELOP.COM
Subject: Re: [DOTNET-WEB] SqlTransaction.Commit

No, you need to explicitly close the connection.


-----Original Message-----
From: Discussion of building .NET applications targeted for
the Web
[mailtoOTNET-WE
BDISCUSS.DEVELOP.COM] On Behalf Of Ainsley, Robert,
ISD
Sent: Tuesday, April 11, 2006 09:55
To: DOTNET-WEBDISCUSS.DEVELOP.COM
Subject: [DOTNET-WEB] SqlTransaction.Commit

I'm trying to track down some SQL connections that aren't
getting closed
in an application.

If I execute a SqlTransaction.Commit, is the connection
associated with
that transaction closed?

I suspect it does because once you commit the transaction,
there is no
longer a connection associated with the transaction.

Thanks,

Bob


************************************************************
************
****
*
If you are not the intended recipient of this e-mail, please
notify the
sender immediately. The contents of this e-mail do not amend
any
existing disclosures or agreements unless expressly stated.
************************************************************
************
****
*

===================================
This list is hosted by DevelopMentor.  http://www.develop.com

View archives and manage your subscription(s) at
http://discuss.develop.com


===================================
This list is hosted by DevelopMentor(r)  http://www.develop.com

View archives and manage your subscription(s) at
http://discuss.develop.com


===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com