DifferencesSummary and ResultsStore disagree

Rodarin

I ran a comparison on the "same" table in two different databases, one of which has had a single column of a single record modified. The DifferencesSummary.DifferenceCount() method of the TableDifference returns 1, and the In1 member of the DifferencesSummary has a value of 1 (which seems incorrect, as I simply modified a row contained in both).

When I look at the ResultsStore member of the TableDifference, it reports a RowCount of 0, and calling GetReader() or GetReader(Row.RowType.In1) on that ResultsStore gives a RowCount of 0.

If the TableDifference.DifferencesSummary knows there is a difference, why can't I get it?

Rodarin

Never fails that you find the answer to your own question after you have given up and asked the world for help. The ComparisonSession.CompareDatabases was called with SessionSettings.IncludeDifferentRecords only, hence the result. Odd, though, that the DifferencesSummary still lets me know about In1 and In2.

James B

Glad to hear you worked it out- I'm not sure why the two would differ like that off the top of my head, but they are two different things of course. I also saw recently that some of the properties in the DifferencesSummary are marked as obsolete now, so that may also be something to do with it.

Let us know if you have any further trouble though!