[Mono-bugs] [Bug 421336] DbCommandBuilder throws exceptions on command creation

bugzilla_noreply at novell.com bugzilla_noreply at novell.com
Fri Aug 29 05:04:47 EDT 2008


User christian_hoff at gmx.net added comment

Christian Hoff <christian_hoff at gmx.net> changed:

           What    |Removed                                         |Added
                 CC|                                                |christian_hoff at gmx.net

--- Comment #2 from Christian Hoff <christian_hoff at gmx.net>  2008-08-29 03:04:46 MDT ---
To explain the issue with the duplicate parameter names:

MS.Net creates this UpdateCommand:
UPDATE `books`.`locations` SET `Description` = @Description, `Capacity` =
@Capacity WHERE ((`ID` = @Original_ID) AND ((@IsNull_Description = 1 AND
`Description` IS NULL) OR (`Description` = @Original_Description)) AND
(`Capacity` = @Original_Capacity))

While Mono would create this(which throws an exception because all parameter
names are used multiple times):
UPDATE `books`.`locations` SET `Description` = @Description, `Capacity` =
@Capacity WHERE ((`ID` = @ID) AND ((@Description = 1 AND `Description` IS NULL)
OR (`Description` = @Description)) AND (`Capacity` = @Capacity))

Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.

More information about the mono-bugs mailing list