A connection to a database is a resource intensive operation that typically comprises a few steps. A channel of communication between the application and the database should be established before the ...

Use profiler.<br><br>SQL leaves them open for a time for the connection pooling of course. -- View image here: http://episteme.arstechnica.com/infopop/emoticons/icon ...

I had been passing username/password strings directly into the ADO.NET connection string, however this means that if a user has a quote character in his password, it borks the ConnectionString and ...