Follow me on Twitter at
FYI, I'm blogging most of my stuff over at More Wally now.
You might want to add my rss feed to your reader at:
Need to clear your connection pool? You can with .NET 2.0. - Wallace B. McClure

Wallace B. McClure

All About Wally McClure - The musings of Wallym on Web, HTML5, Mobile, Xamarin.iOS, Xamarin.Android, and Windows Azure.


Visual Studio Magazine Column Personal Blog


Book Authors




Georgia Tech Bloggers



Need to clear your connection pool? You can with .NET 2.0.

If you need to clear your connection pool in a .NET application, with the .NET 2.0 Whidbey framework, you will have the option of clearing the pool.  ADO.NET 2.0 provides two static methods for doing this.

  • SqlConnection.ClearPool( SqlConnectionObject ).
  • SqlConnection.ClearAllPools().

According to what I have read, this feature will be available in the .NET 2.0 Sql Server and Oracle Clients from Microsoft.



Jerry Pisk said:

Any chance this could be implemented on IDbConnection? I rarely use the specific classes, as I don't want to force my users/coworkers to use a single database engine.
# August 28, 2004 9:47 PM

TheKiN said:

i wondering to know what happend with the current connection that still connected when i clear all pool.

# October 1, 2007 5:15 AM

dev said:

how do you use connection pooling in asp,i want to handle connection poooling in asp not in

pls help !!!!!!!!!

# November 11, 2008 7:59 AM