Reset Connection

[Pinturiccio]

Thank you for the provided information. We will investigate it and notify you about the results as soon as possible.

[Pinturiccio]

We have improved the performance with the 'Connection Reset' connection string parameter. We will notify you when the corresponding build of dotConnect for SQL Server is available for download.

[Pinturiccio]

The new build of dotConnect for SQL Server 2.60.625 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/sqlser ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=25383

[abadia]

I am very grateful for your attention to improve the component.

I built a program to validate the recent improvement. Unfortunately has not had the desired effect. Somewhere sqlCommand to the execution of sp_reset_connection is rebuilt.

The first button validates its implementation. The second button validates the implementation to show the expected operation (although the command is executed at a different time - when the connection opens).

https://skydrive.live.com/redir?resid=B ... Kv7CCAN4VY

[Pinturiccio]

Thank you for the test project. We have reproduced the issue with rebuilding sp_reset_connection of sqlCommand. We will investigate it and notify you about the results as soon as possible.

[Pinturiccio]

SqlCommand is not recreated. Only the sender object is recreated for the SqlMonitor event. Since sender was recreated, it seemed from the test project as though SqlCommand was recreated every time. We have fixed the issue with sender recreation and this fix is already available in the latest version of dotConnect for SQL Server (version 2.60.639). It can be downloaded from http://www.devart.com/dotconnect/sqlser ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).

But these changes will not affect the performance, just the SqlMonitor object event will work more correctly.