using {} with SQLConnection

[Ron]

If I wrap a SQLConnection with a using (...){} block will the connection
automatically be closed if an exception occures? Or will I still need a try
block to catch the exception and close the connection?

Thanks,
Ron

 

[James Swindell]

Using the "using" (i know, i know) will close your database connection.

James

 

[Morten Wennevik]

Hi Ron,

using is considered equal to try/finally. The SqlConnection will be disposed even if an exception occurs.