We have a complex client-server application that was developed using the .NET Framework and uses SQL Server 2005 is. We use LinqToSql but we manage the life time of all connections and we pass an open connection from any datacontent that has been created. We have also used Microsoft WF in this product.
When the server works about one or two, then we end up with some "reclaimed connection", which means that we have some SQL connections We are using all of the code and we have reviewed all the code and have used the potential means to ensure that we are closing any other connections which we are making May include. It seems almost impossible to be open for connections because there are few places where we use them.
Is there a way to find out that SqlConnection.Open ()
or SqlConnection.Close ()
. We need to know where these methods go and who was the caller (maybe it's a call stack.)
thanks
You can use or add to Visual Studio.
No comments:
Post a Comment