Is this okay? Question about connection release?

tylone

if (conn! = null)
                {
                    if (conn.State == ConnectionState.Connecting)
                        conn.Close ();
                    conn.Dispose ();
                }


What is the difference between ConnectionState.Connecting and ConnectionState.Close?

苹果小刀

Trying to connect (this value is reserved for future versions of VS2005)
Disabled

苹果小刀

One is trying to connect (for future version consideration)
One is the connection is closed

kalian2000

Just close it, the GC will automatically recycle it, if not necessary, don't use Dispose ...

The opinions are for reference only.

zibbapan

Using Yes, Dispose will always be called.

cqgang

Dispose is generally not necessary,
.Close can be released to the connection pool

savage698

One using is enough, and convenient

tylone

Would it be wrong if dispose was used?

wudi1982

Would it be wrong if dispose was used?
-------------
No mistake!

zorrozhou

With using, you do n’t need dispose, and using effect is also good