Reply to thread

Here's an example of what I mean using SQLClient:

SQLiteResultSet resultSet;

using (m_db = new SQLiteClient(GetDatabaseName()))

{

    resultSet = m_db.Execute(strSql);

}

return resultSet;

At the end of the using scope, the connection is released.

That does not mean that m_db is closed it just means that any locks are released.

I don't know anyone nowadays that doesn't think that this is the way to go.

Google it