private void CompareResults_1(string Msg, DataSet ds, DataSet dsTarget)
{
// check Parent Primary key length
Assert.Equal(dsTarget.Tables["Parent"].PrimaryKey.Length, ds.Tables["Parent"].PrimaryKey.Length);
// check Child Primary key length
Assert.Equal(dsTarget.Tables["Child"].PrimaryKey.Length, ds.Tables["Child"].PrimaryKey.Length);
// check Parent Primary key columns
Assert.Equal(dsTarget.Tables["Parent"].PrimaryKey[0].ColumnName, ds.Tables["Parent"].PrimaryKey[0].ColumnName);
// check Child Primary key columns[0]
Assert.Equal(dsTarget.Tables["Child"].PrimaryKey[0].ColumnName, ds.Tables["Child"].PrimaryKey[0].ColumnName);
// check Child Primary key columns[1]
Assert.Equal(dsTarget.Tables["Child"].PrimaryKey[1].ColumnName, ds.Tables["Child"].PrimaryKey[1].ColumnName);
// check Parent Unique columns
Assert.Equal(dsTarget.Tables["Parent"].Columns["String2"].Unique, ds.Tables["Parent"].Columns["String2"].Unique);
// check Child2 Foreign Key name
Assert.Equal(dsTarget.Tables["Child2"].Constraints[0].ConstraintName, ds.Tables["Child2"].Constraints[0].ConstraintName);
// check dataset relation count
Assert.Equal(dsTarget.Relations.Count, ds.Relations.Count);
// check dataset relation - Parent column
Assert.Equal(dsTarget.Relations[0].ParentColumns[0].ColumnName, ds.Relations[0].ParentColumns[0].ColumnName);
// check dataset relation - Child column
Assert.Equal(dsTarget.Relations[0].ChildColumns[0].ColumnName, ds.Relations[0].ChildColumns[0].ColumnName);
// check allow null constraint
Assert.Equal(true, dsTarget.Tables["Parent"].Columns["ParentBool"].AllowDBNull);
// check Indentity column
Assert.Equal(dsTarget.Tables["Parent"].Columns.Contains("Indentity"), ds.Tables["Parent"].Columns.Contains("Indentity"));
// check Indentity column - AutoIncrementStep
Assert.Equal(dsTarget.Tables["Parent"].Columns["Indentity"].AutoIncrementStep, ds.Tables["Parent"].Columns["Indentity"].AutoIncrementStep);
// check Indentity column - AutoIncrement
Assert.Equal(dsTarget.Tables["Parent"].Columns["Indentity"].AutoIncrement, ds.Tables["Parent"].Columns["Indentity"].AutoIncrement);
// check Indentity column - DefaultValue
Assert.Equal(true, dsTarget.Tables["Child"].Columns["String1"].DefaultValue == DBNull.Value);
// check remove colum
Assert.Equal(true, dsTarget.Tables["Child"].Columns.Contains("String2"));
}