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

[bugzilla_noreply at novell.com]

https://bugzilla.novell.com/show_bug.cgi?id=421336

User christian_hoff at gmx.net added comment
https://bugzilla.novell.com/show_bug.cgi?id=421336#c2


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.