Erno de Weerd recently posted a blog entry on how SqlConnection.Dispose removes the connection from the connection pool. He concluded this after looking in Reflector and seeing this: 1 protected override void Dispose( bool disposing) 2 { 3 if (disposing) 4 { 5 this ._userConnectionOptions = null ; 6...
Here are the slides and demo code to my DevDays 2006 presentation "ASP.NET 2.0 Black Belt". Make sure you check the hidden slides as well. There's some nice extra info on them. Also, if you visited my talk on the first day, notice the updated slide on the architecture of Query Notifications. I'll explain...