[Mono-bugs] [Bug 53082][Blo] New - Bugs in the DbDataProvider implementation:

[bugzilla-daemon@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 smalinin@amurnet.ru.

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

--- shadow/53082	2004-01-19 21:02:36.000000000 -0500
+++ shadow/53082.tmp.12150	2004-01-19 21:02:36.000000000 -0500
@@ -0,0 +1,118 @@
+Bug#: 53082
+Product: Mono/Class Libraries
+Version: unspecified
+OS: 
+OS Details: 
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Blocker
+Component: Sys.Data
+AssignedTo: mono-bugs@ximian.com                            
+ReportedBy: smalinin@amurnet.ru               
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Bugs in the DbDataProvider implementation:
+
+I found the next problems, when I testing our ADO.NET providers under
+
+
+the Mono enviroment.
+
+
+
+
+1) 'DbDataProvider' implementaion doesn't properly handle the
+
+
+'MissingSchemaAction' property, when MissingSchemaAction == 
+MissingSchemaAction.AddWithKey
+
+
+ When I call the DbDataAdapter.Fill(DataSet, string); method, it doesn't 
+properly add the primary key information.
+
+
+ Sample: DataAdapterUpdate1.cs
+
+
+
+
+2) 'DbDataProvider' implementaion doesn't properly handle the 
+DbDataAdapter.Update(DataSet, string);
+
+
+This method doesn't properly call DataRow.AcceptChanges(), when 
+CommandBuilder is used.
+
+
+ Sample: CmdBuilder1.cs
+
+
+
+
+3) The method DbDataProvider.FillSchema(DataSet, SchemaType.Source, string)
+; doesn't properly fill information about the primary keys.
+
+
+  Sample: DbDataAdapterFillSchema1.cs
+
+
+
+
+All samples works without any problem under the MS.NET Framework.
+
+
+For recreating of my samples, you can use the our OpenLink ADO.NET provider
+
+
+for MS SQL Server:
+
+
+provider =>  http://download.openlinksw.com/uda/open51/ntl5nsql.zip
+
+
+documentation=> http://download.openlinksw.com/uda/open51/opldocu_lt.taz
+
+
+
+
+The sql script for table creation:
+
+
+ create_table.sql
+
+
+
+
+Samples:
+
+
+  DataAdapterUpdate1.cs
+
+
+  CmdBuilder1.cs
+
+
+  DbDataAdapterFillSchema1.cs
+
+
+
+
+Build script: 
+
+
+  build.sh
+
+
+
+
+All problems, that were described above, were fixed.
+
+
+The patch is attached also.
+
+
+patch =>  System.Data.Common.DbDataProvider.diff