[Mono-bugs] [Bug 75552][Maj] New - sqldataadapter.update without column mapping does not work

[bugzilla-daemon at 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 tsureshkumar at novell.com.

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

--- shadow/75552	2005-07-15 04:24:02.000000000 -0400
+++ shadow/75552.tmp.27601	2005-07-15 04:24:02.000000000 -0400
@@ -0,0 +1,73 @@
+Bug#: 75552
+Product: Mono: Class Libraries
+Version: 1.0
+OS: 
+OS Details: 
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Major
+Component: Sys.Data
+AssignedTo: tsureshkumar at novell.com                            
+ReportedBy: tsureshkumar at novell.com               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Summary: sqldataadapter.update without column mapping does not work
+
+pasted from mail from danielmorgan at verizon.net
+
+
+I have a problem with the data adapter on Mono 1.1.8 on Windows.  Has this
+been fixed in svn?
+
+Notice my test case does not use column nor table mappings.
+
+Results on Dot Net 1.1:
+
+E:\projects\DotNet\C#\TestSqlClientAdapter\bin\Debug>TestSqlClientAdapter.exe
+Apapter Test Begin...
+Insert...
+Value 0: 3
+Value 0: Value inserted
+Rows retrieved: 1
+Update...
+Value 0: 3
+Value 0: Value updated
+Rows retrieved: 1
+Delete...
+Rows retrieved: 0
+Done.
+
+Results on Mono 1.1.8 on Windows:
+
+E:\projects\DotNet\C#\TestSqlClientAdapter\bin\Debug>mono
+TestSqlClientAdapter.e
+xe
+Apapter Test Begin...
+Insert...
+
+Unhandled Exception: System.IndexOutOfRangeException:
+DataColumnMappingCollectio
+n doesn't contain DataColumnMapping with SourceColumn 'num_value'.
+in <0x000cd> System.Data.Common.DataColumnMappingCollection:get_Item
+(System.Str
+ing sourceColumn)
+in (wrapper remoting-invoke-with-check)
+System.Data.Common.DataColumnMappingColl
+ection:get_Item (string)
+in <0x001eb> System.Data.SqlClient.SqlCommandBuilder:CreateInsertCommand
+(System
+.Data.DataRow row, System.Data.Common.DataTableMapping tableMapping)
+in (wrapper remoting-invoke-with-check)
+System.Data.SqlClient.SqlCommandBuilder:
+CreateInsertCommand (System.Data.DataRow,System.Data.Common.DataTableMapping)
+in <0x00197> System.Data.SqlClient.SqlCommandBuilder:RowUpdatingHandler
+(System.
+Object sender, System.Data.SqlClient.SqlRowUpdatingEventArgs e)
+
+
+How often does this happen? 
+always
+
+Additional Information: