Where do you connect?

Hiya,

I don't know if this is a simple question or could spark a debate. Where do you attempt to connect to a database? I mean, at what point in code do you connect to your database?

- Brent

not really much of a debate. In the asp.net type world, you want to connect and disconnect as close to the actual work you are doing as possible. since connections are pooled, you can even connect and disconnect multiple times in one request if logic dictates that.
Ah right. I knew connections were pooled by default, but I didn't know if there was any change from other server-side languages.