System.Data.Tests.DataColumnTest2.Expression_ISNULL C# (CSharp) Method

        public void Expression_ISNULL()
        {
            DataSet ds = new DataSet();

            DataTable ptable = new DataTable();
            ptable.Columns.Add("col1", typeof(int));

            DataTable ctable = new DataTable();
            ctable.Columns.Add("col1", typeof(int));
            ctable.Columns.Add("col2", typeof(int));

            ds.Tables.AddRange(new DataTable[] { ptable, ctable });
            ds.Relations.Add("rel1", ptable.Columns[0], ctable.Columns[0]);

            ptable.Rows.Add(new object[] { 1 });
            ptable.Rows.Add(new object[] { 2 });
            for (int i = 0; i < 5; ++i)
                ctable.Rows.Add(new object[] { 1, i });

            // should not throw exception
            ptable.Columns.Add("col2", typeof(int), "IsNull (Sum (Child (rel1).col2), -1)");

            Assert.Equal(10, ptable.Rows[0][1]);
            Assert.Equal(-1, ptable.Rows[1][1]);
        }