public DetailedTableComparisonResult(TableComparisonResult result)
        {
            Origin = result;
            var connectionA = result.GetConnectionA();
            var connectionB = result.GetConnectionB();

            Columns     = result.GetColumns();
            ColumnNames = Columns.Except(PrimaryKey.Columns).Select(n => n.Name).ToArray();
            var aKeys = result.Changes.Where(n => n.Result == CompareResult.NotEqual || n.Result == CompareResult.NotFoundInB).Select(n => n.Key).ToArray();

            TableA = LoadTable(connectionA, aKeys);
            var bKeys = result.Changes.Where(n => n.Result == CompareResult.NotEqual || n.Result == CompareResult.NotFoundInA).Select(n => n.Key).ToArray();

            TableB = LoadTable(connectionB, bKeys);
        }
 public void Add(TableComparisonResult result)
 {
     Tables.Add(result);
 }