VB Destruction

[vass0922]

Ok for lack of a better subject line lol
I'm starting a class in VB.net that will manage database methods. I have a few private objects (sqlcommand, sqlconnection etc) and I have an open database connection method below. This method will be called by another public method within the class. Now my question is if I return a sql connection as follows...


Private Function OpenDBConnection() As SqlConnection

OpenDBConnection = New SqlConnection(g_strConnection)

End Function

how do I close the connection?
I can't set OpenDbConnection = Nothing because the function work like that.
I'm still not quite familiar with this part, so bear with me lol

Now the only other way I've thought it could work is instead of returning the sqlconnection, I could create a private object in the class and set that instead?

[vass0922]

scratch that, just realized for my purposes its better to construct with a sqlconnect object for the class....

although still interested in the answer

[UncaDanno]

You would probably want to have a Close method for the class that passes the Close command on through to your base Connection object.

In the .NET framework, all objects are (supposedly) garbage collected automagically when they are no longer referenced and the memory is needed by something else. You no longer have direct control over when they are ultimately destroyed. The .NET framework and the OS are much more facile than mere mortals at handling things like that. heh

[vass0922]

supposedly being the key word
I'm still gonna close everything "manually" to make sure things are opened and closed correctly.

Thanks