close db connections

[Howard]

using (SqlConnection connection = new SqlConnection(constr))
{
using (SqlCommand command = new SqlCommand(com, connection))
{
//read from db
}
}


Is this sufficient to close db connections or do I need to add
connection.close()..

I know the object will be disposed after this statement but will it close
open db connections?

What is the best practice for running a sql query in asp.net

Thanks,
Howard

 

[Chris Fulstow]

Hi Howard,

Dispose() will close your connection so there's not need to Close() as
well. Unlike Close(), Dispose() will also clear the connection's
ConnectionString, so be careful if you try and Open() it again.

HTH,

Chris

 

[Juan T. Llibre]

Correct.

I would add that the Command object also needs
to be disposed of, not only the Connection object.

So, not only is connection.close() needed,
but command.close() is needed, too.




Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================

 

[Juan T. Llibre]

re:

So, not only is connection.close() needed,
but command.close() is needed, too.

That should have been command.Dispose()



Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================