This post originated from an RSS feed registered with .NET Buzz by Paschal. Original Post: Close() or Dispose()... Feed Title: help.net Feed URL: http://www.asp.net/err404.htm?aspxerrorpath=/pleloup/Rss.aspx Feed Description: .Net for mankind ! Latest .NET Buzz Posts Latest .NET Buzz Posts by Paschal Latest Posts From help.net

Interesting post from Jim Blizzard.Still the debate continue but yes agree MSDN docs are the reference.

Rory asks us (http://neopoleon.com/blog/posts/2889.aspx)

about calling Close() or Dispose() on ADO.NET objects.  He went into ILDASM to see if Dispose() also calls Close(), and sure enough, it does.

And all he had to do was look in the MSDN docs.  Cause we know that the MSDN docs are always right, don't we.  ;)

public void SqlConnectionHereAndGone()

{

SqlConnection myConnection = new

SqlConnection("Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;");

myConnection.Open();

//Calling Dispose also calls SqlConnection.Close.

myConnection.Dispose();

}

Look at that comment in the sample code (straight from MSDN):  "Calling Dispose also calls SqlConnection.Close."

Amazing.  :)