[Mono-bugs] [Bug 68978][Nor] Changed - SqlClient: temporary stored procedures not removed when closing (pooled) connection

[bugzilla-daemon@bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by danielmorgan@verizon.net.

http://bugzilla.ximian.com/show_bug.cgi?id=68978

--- shadow/68978	2004-11-01 10:29:45.000000000 -0500
+++ shadow/68978.tmp.5056	2005-02-20 21:43:13.000000000 -0500
@@ -2,13 +2,13 @@
 Product: Mono: Class Libraries
 Version: unspecified
 OS: All
 OS Details: 
 Status: NEW   
 Resolution: 
-Severity: 
+Severity: Unknown
 Priority: Normal
 Component: Sys.Data
 AssignedTo: mono-bugs@ximian.com                            
 ReportedBy: gert.driesen@pandora.be               
 QAContact: mono-bugs@ximian.com
 TargetMilestone: ---
@@ -80,6 +80,19 @@
 in <0x0004f> (wrapper remoting-invoke-with-check) 
 Mono.Data.Tds.Protocol.Tds:ProcessMessage 
 (Mono.Data.Tds.Protocol.TdsPacketSubType)
 in <0x0014a> Mono.Data.Tds.Protocol.Tds:ProcessSubPacket ()
 in <0x00050> Mono.Data.Tds.Protocol.Tds:NextResult ()
 ...
+
+------- Additional Comments From danielmorgan@verizon.net  2005-02-20 21:43 -------
+There is a stored procedure to reset the connection which cleans up
+anything without actually closing the connection. 
+
+SqlConnection in mono has code for executing the stored procedure
+sp_reset_connection, but the code is currently commented because it
+caused other problems.  I can't remember what they were.
+
+It can be found at:
+mcs/class/System.Data/System.Data.SqlClient/SqlConnection.cs
+in function Open ().
+