Compare identifies rows as Deleted as well as Added

[TomEgg]

Compare identifies records as deleted as well as added, where an "unchanged" might be awaited.

Please see following example: https://dotnetfiddle.net/nDUrTW

Is there any solution, as a workaround comparing the deleted and added after processing does not really feel good.

Thank you.

[Cinchoo]

Issue was the inputs are NOT in sorted order, hence the output are incorrect. You need to sort the input by ID before comparing. Tweaked the fiddle, check it out

https://dotnetfiddle.net/ujb4yq