2 // DataSetInferXmlSchemaTest.cs
5 // Atsushi Enomoto <atsushi@ximian.com>
9 // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
11 // Permission is hereby granted, free of charge, to any person obtaining
12 // a copy of this software and associated documentation files (the
13 // "Software"), to deal in the Software without restriction, including
14 // without limitation the rights to use, copy, modify, merge, publish,
15 // distribute, sublicense, and/or sell copies of the Software, and to
16 // permit persons to whom the Software is furnished to do so, subject to
17 // the following conditions:
19 // The above copyright notice and this permission notice shall be
20 // included in all copies or substantial portions of the Software.
22 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
23 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
24 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
25 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
26 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
27 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
28 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
33 using System.Collections;
37 using NUnit.Framework;
39 namespace MonoTests.System.Data
42 public class DataSetInferXmlSchemaTest : DataSetAssertion
44 string xml1 = "<root/>";
45 string xml2 = "<root attr='value' />";
46 string xml3 = "<root attr='value' attr2='2' />";
47 string xml4 = "<root>simple.txt</root>";
48 string xml5 = "<root><child/></root>";
49 string xml6 = "<root><col1>sample</col1></root>";
50 string xml7 = @"<root>
51 <col1>column 1 test</col1>
52 <col2>column2test</col2>
62 string xml9 = @"<el1 attr1='val1' attrA='valA'>
63 <el2 attr2='val2' attrB='valB'>
64 <el3 attr3='val3' attrC='valC'>3</el3>
67 <el4 attr4='val4' attrD='valD'>4</el4>
71 string xml10 = "<root>Here is a <b>mixed</b> content.</root>";
73 string xml11 = @"<root xml:space='preserve'>
74 <child_after_significant_space />
76 // This is useless ... since xml:space becomes a DataColumn here.
77 // string xml12 = "<root xml:space='preserve'> </root>";
78 // The result is silly under MS.NET. It never ignores comment, so
80 // 1) <root>simple string.</root>
81 // 2) <root>simple <!-- comment -->string.</root>
82 // The same applies to PI.
83 // string xml13 = "<root><tab><col>test <!-- out --> comment</col></tab></root>";
85 // simple namespace/prefix support
86 string xml14 = "<p:root xmlns:p='urn:foo'>test string</p:root>";
87 // two tables that have the same content type.
88 string xml15 = @"<root>
90 <col1_1>test1</col1_1>
91 <col1_2>test2</col1_2>
94 <col2_1>test1</col2_1>
95 <col2_2>test2</col2_2>
98 // foo cannot be both table chikd and root child
99 string xml16 = @"<root>
102 <tableFooChild1>1</tableFooChild1>
103 <tableFooChild2>2</tableFooChild2>
110 // simple namespace support
111 string xml17 = @"<root xmlns='urn:foo' />";
112 // conflict between simple and complex type element col
113 string xml18 = @"<set>
118 <col>simple text here.</col>
121 // variant of xml18: complex column appeared latter
122 string xml19 =@"<set>
124 <col>simple text</col><!-- ignored -->
130 // conflict check (actually it is not conflict) on two "col" tables
131 string xml20 = @"<set>
139 // conflict between the attribute and the child element
140 string xml21 = @"<set>
148 string xml22 = "<set><table><col><descendant/></col></table><table2><col2>v2</col2></table2></set>";
151 string xml23 = @"<set>
152 <xs:schema xmlns:xs='http://www.w3.org/2001/XMLSchema'>
153 <xs:element name='table'>
162 xmlns:msdata='urn:schemas-microsoft-com:xml-msdata'
163 xmlns:diffgr='urn:schemas-microsoft-com:xml-diffgram-v1'>
170 string xml24 = "<p1><p2><p3><p4><p5><p6/></p5></p4></p3></p2></p1>";
173 private DataSet GetDataSet (string xml, string [] nss)
175 DataSet ds = new DataSet ();
176 ds.InferXmlSchema (new XmlTextReader (xml, XmlNodeType.Document, null), nss);
181 public void NullFileName ()
183 DataSet ds = new DataSet ();
184 ds.InferXmlSchema ((XmlReader) null, null);
185 AssertDataSet ("null", ds, "NewDataSet", 0, 0);
189 public void SingleElement ()
191 DataSet ds = GetDataSet (xml1, null);
192 AssertDataSet ("xml1", ds, "root", 0, 0);
194 ds = GetDataSet (xml4, null);
195 AssertDataSet ("xml4", ds, "root", 0, 0);
198 ds = GetDataSet (xml14, null);
199 AssertDataSet ("xml14", ds, "root", 0, 0);
200 Assert.AreEqual (string.Empty, ds.Prefix);
201 Assert.AreEqual ("urn:foo", ds.Namespace);
203 ds = GetDataSet (xml17, null);
204 AssertDataSet ("xml17", ds, "root", 0, 0);
205 Assert.AreEqual ("urn:foo", ds.Namespace);
209 public void SingleElementWithAttribute ()
211 DataSet ds = GetDataSet (xml2, null);
212 AssertDataSet ("ds", ds, "NewDataSet", 1, 0);
213 DataTable dt = ds.Tables [0];
214 AssertDataTable ("dt", dt, "root", 1, 0, 0, 0, 0, 0);
215 AssertDataColumn ("col", dt.Columns [0], "attr", true, false, 0, 1, "attr", MappingType.Attribute, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
219 public void SingleElementWithTwoAttribute ()
221 DataSet ds = GetDataSet (xml3, null);
222 AssertDataSet ("ds", ds, "NewDataSet", 1, 0);
223 DataTable dt = ds.Tables [0];
224 AssertDataTable ("dt", dt, "root", 2, 0, 0, 0, 0, 0);
225 AssertDataColumn ("col", dt.Columns [0], "attr", true, false, 0, 1, "attr", MappingType.Attribute, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
226 AssertDataColumn ("col", dt.Columns [1], "attr2", true, false, 0, 1, "attr2", MappingType.Attribute, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 1, String.Empty, false, false);
230 public void SingleChild ()
232 DataSet ds = GetDataSet (xml5, null);
233 AssertDataSet ("ds", ds, "NewDataSet", 1, 0);
234 DataTable dt = ds.Tables [0];
235 AssertDataTable ("dt", dt, "root", 1, 0, 0, 0, 0, 0);
236 AssertDataColumn ("col", dt.Columns [0], "child", true, false, 0, 1, "child", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
238 ds = GetDataSet (xml6, null);
239 AssertDataSet ("ds", ds, "NewDataSet", 1, 0);
241 AssertDataTable ("dt", dt, "root", 1, 0, 0, 0, 0, 0);
242 AssertDataColumn ("col", dt.Columns [0], "col1", true, false, 0, 1, "col1", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
246 public void SimpleElementTable ()
248 DataSet ds = GetDataSet (xml7, null);
249 AssertDataSet ("ds", ds, "NewDataSet", 1, 0);
250 DataTable dt = ds.Tables [0];
251 AssertDataTable ("dt", dt, "root", 3, 0, 0, 0, 0, 0);
252 AssertDataColumn ("col", dt.Columns [0], "col1", true, false, 0, 1, "col1", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
253 AssertDataColumn ("col2", dt.Columns [1], "col2", true, false, 0, 1, "col2", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 1, String.Empty, false, false);
254 AssertDataColumn ("col3", dt.Columns [2], "col3", true, false, 0, 1, "col3", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 2, String.Empty, false, false);
258 public void SimpleDataSet ()
260 DataSet ds = GetDataSet (xml8, null);
261 AssertDataSet ("ds", ds, "set", 1, 0);
262 DataTable dt = ds.Tables [0];
263 AssertDataTable ("dt", dt, "tab", 3, 0, 0, 0, 0, 0);
264 AssertDataColumn ("col", dt.Columns [0], "col1", true, false, 0, 1, "col1", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
265 AssertDataColumn ("col2", dt.Columns [1], "col2", true, false, 0, 1, "col2", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 1, String.Empty, false, false);
266 AssertDataColumn ("col3", dt.Columns [2], "col3", true, false, 0, 1, "col3", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 2, String.Empty, false, false);
270 public void ComplexElementAttributeTable1 ()
272 // FIXME: Also test ReadXml (, XmlReadMode.InferSchema) and
273 // make sure that ReadXml() stores DataRow to el1 (and maybe to others)
274 DataSet ds = GetDataSet (xml9, null);
275 AssertDataSet ("ds", ds, "NewDataSet", 4, 3);
276 DataTable dt = ds.Tables [0];
278 AssertDataTable ("dt1", dt, "el1", 3, 0, 0, 1, 1, 1);
279 AssertDataColumn ("el1_Id", dt.Columns [0], "el1_Id", false, true, 0, 1, "el1_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, true);
280 AssertDataColumn ("el1_attr1", dt.Columns [1], "attr1", true, false, 0, 1, "attr1", MappingType.Attribute, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 1, String.Empty, false, false);
281 AssertDataColumn ("el1_attrA", dt.Columns [2], "attrA", true, false, 0, 1, "attrA", MappingType.Attribute, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 2, String.Empty, false, false);
284 AssertDataTable ("dt2", dt, "el2", 6, 0, 1, 2, 2, 1);
285 AssertDataColumn ("el2_Id", dt.Columns [0], "el2_Id", false, true, 0, 1, "el2_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, true);
286 AssertDataColumn ("el2_col2", dt.Columns [1], "column2", true, false, 0, 1, "column2", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 1, String.Empty, false, false);
287 AssertDataColumn ("el2_col3", dt.Columns [2], "column3", true, false, 0, 1, "column3", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 2, String.Empty, false, false);
288 AssertDataColumn ("el2_attr2", dt.Columns [3], "attr2", true, false, 0, 1, "attr2", MappingType.Attribute, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 3, String.Empty, false, false);
289 AssertDataColumn ("el2_attrB", dt.Columns [4], "attrB", true, false, 0, 1, "attrB", MappingType.Attribute, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 4, String.Empty, false, false);
290 AssertDataColumn ("el2_el1Id", dt.Columns [5], "el1_Id", true, false, 0, 1, "el1_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, 5, String.Empty, false, false);
293 AssertDataTable ("dt3", dt, "el3", 4, 0, 1, 0, 1, 0);
294 AssertDataColumn ("el3_attr3", dt.Columns [0], "attr3", true, false, 0, 1, "attr3", MappingType.Attribute, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
295 AssertDataColumn ("el3_attrC", dt.Columns [1], "attrC", true, false, 0, 1, "attrC", MappingType.Attribute, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 1, String.Empty, false, false);
296 AssertDataColumn ("el3_Text", dt.Columns [2], "el3_Text", true, false, 0, 1, "el3_Text", MappingType.SimpleContent, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 2, String.Empty, false, false);
297 AssertDataColumn ("el3_el2Id", dt.Columns [3], "el2_Id", true, false, 0, 1, "el2_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, 3, String.Empty, false, false);
300 AssertDataTable ("dt4", dt, "el4", 4, 0, 1, 0, 1, 0);
301 AssertDataColumn ("el3_attr4", dt.Columns [0], "attr4", true, false, 0, 1, "attr4", MappingType.Attribute, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
302 AssertDataColumn ("el4_attrD", dt.Columns [1], "attrD", true, false, 0, 1, "attrD", MappingType.Attribute, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 1, String.Empty, false, false);
303 AssertDataColumn ("el4_Text", dt.Columns [2], "el4_Text", true, false, 0, 1, "el4_Text", MappingType.SimpleContent, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 2, String.Empty, false, false);
304 AssertDataColumn ("el4_el2Id", dt.Columns [3], "el2_Id", true, false, 0, 1, "el2_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, 3, String.Empty, false, false);
308 public void MixedContent ()
310 // Note that text part is ignored.
312 DataSet ds = GetDataSet (xml10, null);
313 AssertDataSet ("ds", ds, "NewDataSet", 1, 0);
314 DataTable dt = ds.Tables [0];
315 AssertDataTable ("dt", dt, "root", 1, 0, 0, 0, 0, 0);
316 AssertDataColumn ("col", dt.Columns [0], "b", true, false, 0, 1, "b", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
320 public void SignificantWhitespaceIgnored ()
322 // Note that 1) significant whitespace is ignored, and
323 // 2) xml:space is treated as column (and also note namespaces).
324 DataSet ds = GetDataSet (xml11, null);
325 AssertDataSet ("ds", ds, "NewDataSet", 1, 0);
326 DataTable dt = ds.Tables [0];
327 AssertDataTable ("dt", dt, "root", 1, 0, 0, 0, 0, 0);
328 AssertDataColumn ("element", dt.Columns [0], "child_after_significant_space", true, false, 0, 1, "child_after_significant_space", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
329 Assert.AreEqual (1, dt.Columns.Count, "xml:space is not treated as column");
333 public void SignificantWhitespaceIgnored2 ()
335 // To make sure, create pure significant whitespace element
336 // using XmlNodeReader (that does not have xml:space attribute
338 DataSet ds = new DataSet ();
339 XmlDocument doc = new XmlDocument ();
340 doc.AppendChild (doc.CreateElement ("root"));
341 doc.DocumentElement.AppendChild (doc.CreateSignificantWhitespace
343 XmlReader xr = new XmlNodeReader (doc);
344 ds.InferXmlSchema (xr, null);
345 AssertDataSet ("pure_whitespace", ds, "root", 0, 0);
349 public void TwoElementTable ()
351 // FIXME: Also test ReadXml (, XmlReadMode.InferSchema) and
352 // make sure that ReadXml() stores DataRow to el1 (and maybe to others)
353 DataSet ds = GetDataSet (xml15, null);
354 AssertDataSet ("ds", ds, "root", 2, 0);
356 DataTable dt = ds.Tables [0];
357 AssertDataTable ("dt", dt, "table1", 2, 0, 0, 0, 0, 0);
358 AssertDataColumn ("col1_1", dt.Columns [0], "col1_1", true, false, 0, 1, "col1_1", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
359 AssertDataColumn ("col1_2", dt.Columns [1], "col1_2", true, false, 0, 1, "col1_2", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 1, String.Empty, false, false);
362 AssertDataTable ("dt", dt, "table2", 2, 0, 0, 0, 0, 0);
363 AssertDataColumn ("col2_1", dt.Columns [0], "col2_1", true, false, 0, 1, "col2_1", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
364 AssertDataColumn ("col2_2", dt.Columns [1], "col2_2", true, false, 0, 1, "col2_2", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 1, String.Empty, false, false);
368 [Category ("NotWorking")]
369 [ExpectedException (typeof (ArgumentException))]
370 // The same table cannot be the child table in two nested relations.
371 public void ComplexElementTable1 ()
373 // TODO: Also test ReadXml (, XmlReadMode.InferSchema) and
374 // make sure that ReadXml() stores DataRow to el1 (and maybe to others)
375 DataSet ds = GetDataSet (xml16, null);
377 AssertDataSet ("ds", ds, "NewDataSet", 4, 0);
379 DataTable dt = ds.Tables [0];
380 AssertDataTable ("dt", dt, "root", 2, 0);
381 AssertDataColumn ("table#1_id", dt.Columns [0], "root_Id", false, true, 0, 1, "root_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, true);
382 AssertDataColumn ("table#1_bar", dt.Columns [1], "bar", true, false, 0, 1, "bar", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 1, String.Empty, false, false);
385 AssertDataTable ("dt2", dt, "table", 3, 0);
386 AssertDataColumn ("table#2_id", dt.Columns [0], "table_Id", false, true, 0, 1, "table_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, true);
387 AssertDataColumn ("table#2_bar", dt.Columns [1], "bar", true, false, 0, 1, "bar", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 1, String.Empty, false, false);
388 AssertDataColumn ("table#2_refid", dt.Columns [0], "root_Id", true, false, 0, 1, "root_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, 2, String.Empty, false, false);
391 AssertDataTable ("dt3", dt, "foo", 3, 0);
392 AssertDataColumn ("table#3_col1", dt.Columns [0], "tableFooChild1", true, false, 0, 1, "tableFooChild1", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
393 AssertDataColumn ("table#3_col2", dt.Columns [0], "tableFooChild2", true, false, 0, 1, "tableFooChild2", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 1, String.Empty, false, false);
394 AssertDataColumn ("table#3_refid", dt.Columns [0], "table_Id", true, false, 0, 1, "table_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, 2, String.Empty, false, false);
399 public void ConflictSimpleComplexColumns ()
401 DataSet ds = GetDataSet (xml18, null);
402 AssertDataSet ("ds", ds, "set", 2, 1);
404 DataTable dt = ds.Tables [0];
405 AssertDataTable ("dt", dt, "table", 1, 0, 0, 1, 1, 1);
406 AssertDataColumn ("table_Id", dt.Columns [0], "table_Id", false, true, 0, 1, "table_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, true);
409 AssertDataTable ("dt", dt, "col", 2, 0, 1, 0, 1, 0);
410 AssertDataColumn ("another_col", dt.Columns [0], "another_col", true, false, 0, 1, "another_col", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
411 AssertDataColumn ("table_refId", dt.Columns [1], "table_Id", true, false, 0, 1, "table_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, 1, String.Empty, false, false);
413 DataRelation dr = ds.Relations [0];
414 AssertDataRelation ("rel", dr, "table_col", true, new string [] {"table_Id"}, new string [] {"table_Id"}, true, true);
415 AssertUniqueConstraint ("uniq", dr.ParentKeyConstraint, "Constraint1", true, new string [] {"table_Id"});
416 AssertForeignKeyConstraint ("fkey", dr.ChildKeyConstraint, "table_col", AcceptRejectRule.None, Rule.Cascade, Rule.Cascade, new string [] {"table_Id"}, new string [] {"table_Id"});
420 public void ConflictColumnTable ()
422 DataSet ds = GetDataSet (xml19, null);
423 AssertDataSet ("ds", ds, "set", 2, 1);
425 DataTable dt = ds.Tables [0];
426 AssertDataTable ("dt", dt, "table", 1, 0, 0, 1, 1, 1);
427 AssertDataColumn ("table_Id", dt.Columns [0], "table_Id", false, true, 0, 1, "table_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, true);
430 AssertDataTable ("dt", dt, "col", 2, 0, 1, 0, 1, 0);
431 AssertDataColumn ("table_refId", dt.Columns ["table_Id"], "table_Id", true, false, 0, 1, "table_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, /*0*/-1, String.Empty, false, false);
432 AssertDataColumn ("another_col", dt.Columns ["another_col"], "another_col", true, false, 0, 1, "another_col", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, /*1*/-1, String.Empty, false, false);
434 DataRelation dr = ds.Relations [0];
435 AssertDataRelation ("rel", dr, "table_col", true, new string [] {"table_Id"}, new string [] {"table_Id"}, true, true);
436 AssertUniqueConstraint ("uniq", dr.ParentKeyConstraint, "Constraint1", true, new string [] {"table_Id"});
437 AssertForeignKeyConstraint ("fkey", dr.ChildKeyConstraint, "table_col", AcceptRejectRule.None, Rule.Cascade, Rule.Cascade, new string [] {"table_Id"}, new string [] {"table_Id"});
441 public void ConflictColumnTableAttribute ()
443 // Conflicts between a column and a table, additionally an attribute.
444 DataSet ds = GetDataSet (xml20, null);
445 AssertDataSet ("ds", ds, "set", 2, 1);
447 DataTable dt = ds.Tables [0];
448 AssertDataTable ("dt", dt, "table", 1, 0, 0, 1, 1, 1);
449 AssertDataColumn ("table_Id", dt.Columns [0], "table_Id", false, true, 0, 1, "table_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, true);
452 AssertDataTable ("dt", dt, "col", 3, 0, 1, 0, 1, 0);
453 AssertDataColumn ("another_col", dt.Columns [0], "another_col", true, false, 0, 1, "another_col", MappingType.Element, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, 0, String.Empty, false, false);
454 AssertDataColumn ("table_refId", dt.Columns ["table_Id"], "table_Id", true, false, 0, 1, "table_Id", MappingType.Hidden, typeof (int), DBNull.Value, String.Empty, -1, String.Empty, /*1*/-1, String.Empty, false, false);
455 AssertDataColumn ("attr", dt.Columns ["attr"], "attr", true, false, 0, 1, "attr", MappingType.Attribute, typeof (string), DBNull.Value, String.Empty, -1, String.Empty, /*2*/-1, String.Empty, false, false);
457 DataRelation dr = ds.Relations [0];
458 AssertDataRelation ("rel", dr, "table_col", true, new string [] {"table_Id"}, new string [] {"table_Id"}, true, true);
459 AssertUniqueConstraint ("uniq", dr.ParentKeyConstraint, "Constraint1", true, new string [] {"table_Id"});
460 AssertForeignKeyConstraint ("fkey", dr.ChildKeyConstraint, "table_col", AcceptRejectRule.None, Rule.Cascade, Rule.Cascade, new string [] {"table_Id"}, new string [] {"table_Id"});
464 [ExpectedException (typeof (DataException))]
465 public void ConflictAttributeDataTable ()
467 // attribute "data" becomes DataTable, and when column "data"
468 // appears, it cannot be DataColumn, since the name is
469 // already allocated for DataTable.
470 DataSet ds = GetDataSet (xml21, null);
474 [ExpectedException (typeof (ConstraintException))]
475 public void ConflictExistingPrimaryKey ()
477 // <wrong>The 'col' DataTable tries to create another primary key (and fails)</wrong> The data violates key constraint.
478 DataSet ds = new DataSet ();
479 ds.Tables.Add (new DataTable ("table"));
480 DataColumn c = new DataColumn ("pk");
481 ds.Tables [0].Columns.Add (c);
482 ds.Tables [0].PrimaryKey = new DataColumn [] {c};
483 XmlTextReader xtr = new XmlTextReader (xml22, XmlNodeType.Document, null);
485 ds.ReadXml (xtr, XmlReadMode.InferSchema);
489 public void IgnoredNamespaces ()
491 string xml = "<root attr='val' xmlns:a='urn:foo' a:foo='hogehoge' />";
492 DataSet ds = new DataSet ();
493 ds.InferXmlSchema (new StringReader (xml), null);
494 AssertDataSet ("ds", ds, "NewDataSet", 1, 0);
495 AssertDataTable ("dt", ds.Tables [0], "root", 2, 0, 0, 0, 0, 0);
498 ds.InferXmlSchema (new StringReader (xml), new string [] {"urn:foo"});
499 AssertDataSet ("ds", ds, "NewDataSet", 1, 0);
501 AssertDataTable ("dt", ds.Tables [0], "root", 1, 0, 0, 0, 0, 0);
505 public void ContainsSchema ()
507 DataSet ds = new DataSet();
508 DataTable dt1 = new DataTable();
510 DataColumn dc1 = new DataColumn("Col1");
511 dt1.Columns.Add(dc1);
512 dt1.Rows.Add(new string[] { "aaa" } );
513 DataTable dt2 = new DataTable();
515 DataColumn dc2 = new DataColumn("Col2");
516 dt2.Columns.Add(dc2);
517 dt2.Rows.Add(new string[] { "bbb" } );
519 DataRelation rel = new DataRelation("Rel1",dc1,dc2,false);
520 ds.Relations.Add(rel);
522 StringWriter sw = new StringWriter ();
523 ds.WriteXml(sw, XmlWriteMode.WriteSchema);
526 ds.ReadXml(new StringReader (sw.ToString ()));
527 sw = new StringWriter ();
529 XmlDocument doc = new XmlDocument ();
530 doc.LoadXml (sw.ToString ());
531 Assert.AreEqual (2, doc.DocumentElement.ChildNodes.Count);