Bug #62246 Connector/Net Incorrectly Maps Decimal To AnsiString

• Submitted: 24 Aug 2011 6:38
• Modified: 6 Oct 2011 20:40
• Reporter: billy cat
• Status: Closed
• Category: Connector / NET
• Severity: S3 (Non-critical)
• Version: 6.4.3
• OS: Windows
• Assigned to: Gabriela Martinez Sanchez
• CPU Architecture: Any

[24 Aug 2011 6:38] billy cat

Description:
When I use VS2010, Connector/Net 6.4.3 to build the Typed DataSet from mysql, there was an error.

One field of a table in mysql was define to Decimal(10,2), and when i build the Typed DataSet with VS2010, it create the DataAdapter with Insert,Update,Delete method automatic, but the patamters of that methods seems to be wrong with the type Decimal. It was changed to be type String in C#.

It seams to be maped to the type decimal in C#.

How to repeat:
Step 1. create a table in mysql with one field was defined in type Decimal(10,2), and make sure there is a primary key with the table

Step 2. open a solution in VS2010, add a DataSet into a project(bulid a .xsd file) with the table created in Step 1.

Step 3. with the Typed DataSet, then create a dataadapter in Typed DataSet, then   can see the Insert Method with the error paramter with decimal, it was changed to string.

[6 Oct 2011 20:40] Gabriela Martinez Sanchez

Fixed on versions 6.3+ and 6.4+

[10 Oct 2011 19:23] Philip Olson

This is fixed as of 6.4.5:

+        Connector/NET would incorrectly map decimal values to ANSI
+        strings.