The fastest way to search for unclosed SqlConnection

Question

The fastest way to search for unclosed SqlConnection

I have an ASP.NET web application that periodically returns the following, annoying error:

Timed out. Waiting period before receiving connection to the pool. Perhaps this happened because all pooled connections were used and the maximum pool size was reached.

My manager suspects that this is due SqlConnectionto the application being unclosed . Therefore, I am currently manually checking each code file in the application to see if any connections have been opened.

Is there a faster solution to finding the root of this error?

+3

asp.net timeout connection-timeout

Curt May 18 '12 at 15:47

source share

1 answer

JerKimball · Accepted Answer · 2012-10-02T05:41:36+0000

Bouquet of different options:

Resharper " " ( " " ): http://blogs.jetbrains.com/dotnet/2010/04/introducing-resharper-50-structural-search-and-replace/
FxCop Roslyn ( , SqlConnection )
SqlConnection ( , ), / .
WinDbg "" , .
(SciTech - ), .

The fastest way to search for unclosed SqlConnection

More articles: