2 // Rafael Mizrahi <rafim@mainsoft.com>
3 // Erez Lotan <erezl@mainsoft.com>
4 // Oren Gurfinkel <oreng@mainsoft.com>
7 // Copyright (c) 2004 Mainsoft Co.
9 // Permission is hereby granted, free of charge, to any person obtaining
10 // a copy of this software and associated documentation files (the
11 // "Software"), to deal in the Software without restriction, including
12 // without limitation the rights to use, copy, modify, merge, publish,
13 // distribute, sublicense, and/or sell copies of the Software, and to
14 // permit persons to whom the Software is furnished to do so, subject to
15 // the following conditions:
17 // The above copyright notice and this permission notice shall be
18 // included in all copies or substantial portions of the Software.
20 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
21 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
22 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
23 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
24 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
25 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
26 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
29 using NUnit.Framework;
38 namespace tests.system_data_dll.System_Data
40 [TestFixture] public class DataRow_GetParentRows_D : GHTBase
42 [Test] public void Main()
44 DataRow_GetParentRows_D tc = new DataRow_GetParentRows_D();
48 tc.BeginTest("DataRow_GetParentRows_D");
61 //Activate This Construntor to log All To Standard output
62 //public TestClass():base(true){}
64 //Activate this constructor to log Failures to a log file
65 //public TestClass(System.IO.TextWriter tw):base(tw, false){}
68 //Activate this constructor to log All to a log file
69 //public TestClass(System.IO.TextWriter tw):base(tw, true){}
71 //BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES
78 DataRow[] drArrExcepted,drArrResult;
79 DataTable dtChild,dtParent;
80 DataSet ds = new DataSet();
83 dtChild = GHTUtils.DataProvider.CreateChildDataTable();
84 dtParent = GHTUtils.DataProvider.CreateParentDataTable();
86 //Add tables to dataset
87 ds.Tables.Add(dtChild);
88 ds.Tables.Add(dtParent);
89 dr = dtParent.Rows[0];
91 //Duplicate several rows in order to create Many to Many relation
92 dtParent.ImportRow(dr);
93 dtParent.ImportRow(dr);
94 dtParent.ImportRow(dr);
97 DataRelation dRel = new DataRelation("Parent-Child",dtParent.Columns["ParentId"],dtChild.Columns["ParentId"],false);
98 ds.Relations.Add(dRel);
100 drArrExcepted = dtParent.Select("ParentId=" + dr["ParentId"]);
101 dr = dtChild.Select("ParentId=" + dr["ParentId"])[0];
103 drArrResult = dr.GetParentRows(dRel);
107 BeginCase("GetParentRows_D");
108 base.Compare( drArrResult, drArrExcepted);
110 catch(Exception ex) {exp = ex;}
111 finally {EndCase(exp); exp = null;}