-----------------------------------------------------------

New Message on MumbaiUserGroup

-----------------------------------------------------------
From: Nasha
Message 2 in Discussion


Hi,
 
Dispose() invokes the protected Dispose(Boolean) method with the 
disposing parameter set to true. Finalize invokes Dispose with disposing set to 
false.
 
When 
the disposing parameter is true, this method releases all resources held by any 
managed objects that this SqlConnection references. This method invokes the 
Dispose() method of each referenced object.
 
Dispose can be called multiple times by other objects. When overriding 
Dispose(Boolean), be careful not to reference objects that have been previously 
disposed of in an earlier call to Dispose. For more information about how to 
implement Dispose(Boolean), see Implementing a Dispose 
Method.
 
For 
more information about Dispose and Finalize, see Cleaning Up Unmanaged Resources 
and Overriding the Finalize Method.
 
The 
Dispose method calls Close, and returns the SqlConnection to the connection 
pool.
 
For 
more details refer to
ms-help://MS.VSCC.2003/MS.MSDNQTR.2003JUL.1033/cpref/html/frlrfSystemDataSqlClientSqlConnectionClassDisposeTopic1.htm
 
Regards,
Namratha.
 

  -----Original Message-----
From: MumbaiUserGroup 
  [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 
  10:45 AM
To: MumbaiUserGroup
Subject: Question about 
  Dispose


  
    
      
      New Message on MumbaiUserGroup
    
      

  Question 
    about Dispose


    
      
      
        Reply

        
          
            
            
               
              Recommend 
              Message 1 in 
                Discussion 
      
        
          
            
            
              From: Ashish_Bhonkiya 
            
            
              
Hi All,

Are there any best 
                practices when to call Close() and Dispose() methods of 
                sqlConnection object. 

Calling dispose() have any impact 
                on Connection Pooling ?

Regards
Ashish M 
            Bhonkiya
View other groups in this 
    category. 



-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the "Remove" link below. On the pre-addressed 
e-mail message that opens, simply click "Send". Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to