Close connection in finalizer

alainc

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

alainc21y ago
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
shimtanny21y ago
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