https://bugzilla.novell.com/show_bug.cgi?id=419316
Summary: SourceColumnNullMapping property of DbParameter Ignored
in DbDataAdapter.Update
Product: Mono: Class Libraries
Version: 1.9
Platform: x86
OS/Version: Windows XP
Status: NEW
Severity: Major
Priority: P5 - None
Component: Sys.Data
AssignedTo: [EMAIL PROTECTED]
ReportedBy: [EMAIL PROTECTED]
QAContact: [email protected]
Found By: Development
Description of Problem:
The SourceColumnNullMapping property appears to be ignored in the
DbDataAdapter.Update method. in .NET, if the source column value is null, the
parameter value becomes 0. If the source column value is not null, the
parameter value becomes 1.
Steps to reproduce the problem:
1. Use the MySql 5.2.2 Designer in Visual Studio to create a typed data set
2. One column in the resulting table must be nullable.
3. The MySql designer sets the SourceColumnNullMapping property for internal
use
4. Verify that a parameter on the UpdateCommand of the typed data adapter has
the SourceColumnNullMapping property set to True
4. Fill the data set
5. Make a change to a field. Ensure that there is a value in one of the
nullable fields
6. Create an instance of the typed data adapter.
7. Call .Update on the typed data adapter
8. Exception is thrown
Actual Results:
System.FormatException is thrown from the MySql Data providers when it attempts
to convert the column's actual value to an int32.
Expected Results:
After DbDataAdapter finds its source column and sets the parameter value, it
should check the parameter SourceColumnNullMapping property, and based on that
change the parameter value to 1 or 0 accordingly.
How often does this happen?
Every time Update is called
Additional Information:
--
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
_______________________________________________
mono-bugs maillist - [email protected]
http://lists.ximian.com/mailman/listinfo/mono-bugs
