I've been reading this article... http://www.fawcette.com/vsm/2004_05/online/esabbadin/ ... and had some questions. I've always thought that you should only have a connection to a database open for the shortest time needed. In this article though, it talks about opening the connection in the constructor. If you open it in the constructor, then it's basically open for the life of that object instance, right? If so, that goes against everything I was taught about only creating an instance of a connection when you need it. There were things in this article that I didn't quite understand and maybe that takes care of some of my questions... If I open the connection in my constructor, when then do I close it? I wouldn't want to just let it sit there waiting for the GC to come and take care of my object and it's associated connection would I? Thanks.