|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
iDisposable and database connection to SQLI have created a class that connects to a SQL database when it is
created. This is a maintenance application that re-creates this class at regular intervals. I am worried that I will be creating a lot of connections to the database and leaving them open until the GC decides to clean them. When the variable for the class goes out of scope is the database connection closed or will it remain ipen until the GC fires? This object may get created every 10 minutes. Should I implement iDisposable and use the 'Using' block when I create this object? Thank you! Karl Karl,
Why isn't your app explicitly closing its connection to the database? Kerry Moorman Show quoteHide quote "karl" wrote: > I have created a class that connects to a SQL database when it is > created. This is a maintenance application that re-creates this class > at regular intervals. I am worried that I will be creating a lot of > connections to the database and leaving them open until the GC decides > to clean them. When the variable for the class goes out of scope is the > database connection closed or will it remain ipen until the GC fires? > This object may get created every 10 minutes. > > Should I implement iDisposable and use the 'Using' block when I create > this object? > > > Thank you! > Karl > > Everything is handled by the class so it should be able to close the
connection when it is disposed of. I didn't really want the application to have to tell it that is was done with it. That is why I was thinking about using the Dispose sub... Thanks Karl Karl,
If you dispose or close it is in this class not so important, the dispose calls the close. However the GC is never disposing so will not close as well. Cor Show quoteHide quote "karl" <karl***@pacbell.net> schreef in bericht news:1147888284.784293.270150@i39g2000cwa.googlegroups.com... > Everything is handled by the class so it should be able to close the > connection when it is disposed of. I didn't really want the application > to have to tell it that is was done with it. That is why I was thinking > about using the Dispose sub... > > Thanks > Karl > 
Other interesting topics
Get Element Value
MAPI mail Create DB Example - It works, but is it right? Cannot insert explict value for identity column in table 'Employees' when IDENTITY_INSERT is set to XML From Stored Proc Listbox problem Using Office functions question - type mismatch error how to go to specific row in hashtable based on value - not key? Web Browser & Navigating to pages with errors Different versions of Office |
|||||||||||||||||||||||
