Follow me on Twitter at Twitter.com/wbm
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:http://morewally.com/cs/blogs/wallym/rss.aspx
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.

News

Visual Studio Magazine Column Personal Blog

.NET

Book Authors

Business

Family

Friends

Georgia Tech Bloggers

Personal

Archives

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.

Enjoy,
Wally

Comments

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 asp.net.

pls help !!!!!!!!!

# November 11, 2008 7:59 AM