I've noticed that if I use a statement lik
using(StreamWriter sw = new StreamWriter(@"c:\filetowriteto.txt")
{...
then the file gets released at the end of the using statement block
However if I use this on a database connection
using(SqlConnection cndb = new SqlConnection(@"....")
{...
then unless I explicitly call Close, it doesn't close it. Certainly not with SQ
server connections anyway, they're still visible in Enterprise manager unti
you call close
What is it with IDisposable - what does it actually DO? Is there any goo
description of what resources it frees and what it doesn't
Can you derive from it to define exactly what resources you want to free