[Mono-bugs] [Bug 77557][Nor] New - System.Data.DataSet WriteXmlSchema does not write ForeignKeyConstraints

[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 john_marchesini at symantec.com.

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

--- shadow/77557	2006-02-14 18:07:10.000000000 -0500
+++ shadow/77557.tmp.11878	2006-02-14 18:07:10.000000000 -0500
@@ -0,0 +1,109 @@
+Bug#: 77557
+Product: Mono: Class Libraries
+Version: 1.1
+OS: 
+OS Details: RedHat 2.6.11-1.1369_FC4smp
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Normal
+Component: Sys.Data
+AssignedTo: tsenganal at novell.com                            
+ReportedBy: john_marchesini at symantec.com               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: System.Data.DataSet WriteXmlSchema does not write ForeignKeyConstraints
+
+Description of Problem: The System.Data.DataSet.WriteXmlSchema() method
+does not write ForeignKeyConstraints.  This behavior is different than the
+Windows .NET Framework 1.1.
+
+Steps to reproduce the problem:
+1. Get the attached sample program to your system.
+2. Compile using 'mcs -r:System.Data Dump.cs'
+3. Run using 'mono Dump.exe'
+
+Actual Results:
+
+<?xml version="1.0" encoding="utf-8"?>
+<xs:schema id="TestDataset" xmlns=""
+xmlns:xs="http://www.w3.org/2001/XMLSchema"
+xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
+  <xs:element name="TestDataset" msdata:IsDataSet="true" msdata:Locale="en-US">
+    <xs:complexType>
+      <xs:choice maxOccurs="unbounded">
+        <xs:element name="Directories">
+          <xs:complexType>
+            <xs:sequence>
+              <xs:element name="UID" type="xs:string"
+msdata:DataType="System.Guid, mscorlib, Version=1.0.5000.0,
+Culture=neutral, PublicKeyToken=b77a5c561934e089" />
+            </xs:sequence>
+          </xs:complexType>
+        </xs:element>
+        <xs:element name="Files">
+          <xs:complexType>
+            <xs:sequence>
+              <xs:element name="DirectoryID" type="xs:string"
+msdata:DataType="System.Guid, mscorlib, Version=1.0.5000.0,
+Culture=neutral, PublicKeyToken=b77a5c561934e089" />
+            </xs:sequence>
+          </xs:complexType>
+        </xs:element>
+      </xs:choice>
+    </xs:complexType>
+    <xs:unique name="Constraint1">
+      <xs:selector xpath=".//Directories" />
+      <xs:field xpath="UID" />
+    </xs:unique>
+  </xs:element>
+</xs:schema>
+
+Expected Results: (Results from running Dump.exe on the Windows .NET
+Framework 1.1)
+
+<?xml version="1.0" encoding="IBM437"?>
+<xs:schema id="TestDataset" xmlns=""
+xmlns:xs="http://www.w3.org/2001/XMLSchema"
+xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
+  <xs:element name="TestDataset" msdata:IsDataSet="true">
+    <xs:complexType>
+      <xs:choice maxOccurs="unbounded">
+        <xs:element name="Directories">
+          <xs:complexType>
+            <xs:sequence>
+              <xs:element name="UID" msdata:DataType="System.Guid,
+mscorlib, Version=1.0.5000.0, Culture=neutral,
+PublicKeyToken=b77a5c561934e089" type="xs:string" />
+            </xs:sequence>
+          </xs:complexType>
+        </xs:element>
+        <xs:element name="Files">
+          <xs:complexType>
+            <xs:sequence>
+              <xs:element name="DirectoryID" msdata:DataType="System.Guid,
+mscorlib, Version=1.0.5000.0, Culture=neutral,
+PublicKeyToken=b77a5c561934e089" type="xs:string" />
+            </xs:sequence>
+          </xs:complexType>
+        </xs:element>
+      </xs:choice>
+    </xs:complexType>
+    <xs:unique name="Constraint1">
+      <xs:selector xpath=".//Directories" />
+      <xs:field xpath="UID" />
+    </xs:unique>
+    <xs:keyref name="FK_Test" refer="Constraint1" msdata:ConstraintOnly="true">
+      <xs:selector xpath=".//Files" />
+      <xs:field xpath="DirectoryID" />
+    </xs:keyref>
+  </xs:element>
+</xs:schema>
+
+How often does this happen? 
+- Always on Mono 1.1.13
+- Cannot repro on WinXP sp2 .NET Framework 1.1.
+
+Additional Information: