Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ben Kubicek Using Redgate API to compare data in the same table RE: Using Redgate API to compare data in the same table

  • October 16, 2018 at 4:16 am

    #2009825

    andyo.dev - Tuesday, October 16, 2018 2:06 AM

    If you didn't have Redgate you could use an orm like entity framework or dapper to read each pair of rows in at a time.
    Giving two instances of a row as an object.
    Serialise them and compare the two strings.
    If you needed to know which field was different.
    Use reflection to get a list of public properties and iterate through their values using tostring() on each to get a consistent value and compare those.

    Do you have a solution working?  It would be interesting to see an example.  I have done things similar to what you are suggesting in the past.  They tend to be a lot more work then the solution I outlined in my article.  What I really like about my solution is most of the heavy lifting it done by the redgate API.
    Thanks for your post.
    Ben