Close connection in finalizer

Question

In a class of my asp.net application I open connection in constructor and I want close connection in finalizer method but .close fails. I have read this http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlconnectionclassclosetopic.asp CAUTION Do not call Close or Dispose on a Connection a DataReader or any other managed object in the Finalize method of your class. In a finalizer you should only release unmanaged resources that your class owns directly. If your class does not own any unmanaged resources do not include a Finalize method in your class definition. For more information see Programming for Garbage Collection. How can I close this connection? Thankssss

alainc · Answer

This is the error: An unhandled exception of type 'System.InvalidOperationException' occurred in mscorlib.dll Additional information: Handle is not initialized. I want to avoid to open and to close the connection to gain time. If i do a method for close connection the programer can forget it. Thanks PD: sorry by my english i'm spanish

shimtanny · Answer

Hi What does .close fails mean? Exceptions? Still an open connection (recognized by temporary files or similar)? ... But anyway you should close connections to the db as soon as you don't need it (in a method). Typically there is a try/catch/finally statement. Put the connection.Close() in the finally statement. Simon