I normally do not use "using".
The issue is that I normally have more than one thing to close.
Multiple "using" statements make the sourec look awfull, indentaion wise.
Multiple closingsin the finally do not.
--
Regards
Thomas Tomiczek
THONA Software & Consulting Ltd.
(Microsoft MVP C#/.NET)
(CTO PowerNodes Ltd.)
---
Still waiting for ObjectSpaces? Try the EntityBroker today - more versatile,
more powerfull.
And something in use NOW. for the projects you have to deliver - NOW.
"CSharper" <do**@botherme.com> wrote in message
news:d7********************@bignews4.bellsouth.net ...
They're basically the same thing. Either way is still better than simply
setting it to null, since the SqlConnection's Dispose method explicitly
closes the connection.
Dan Cox
"Dan Shanyfelt MCAD" <da*************@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com... Is it better to go with the
finally {conn.dispose;}
or
using (con = new conn)
?
-Dan