I would like to keep a simple hash value of n number of columns, for example. address and name, and save the hash in another column. I want to use a hash value as a quick way to synchronize data between two sources by simply comparing the hash value. What is the best way to do something like this. I do not need crypto function to create a hash.
eg.
John Smith, 1 Long Lane Road, Village, City, Zip / Postal Code. Hash: AK67KS38
I would like the hash value to be easy enough to read (not the whole set of Uni code).
Edit
Okay, I would still like to do this in C # and LINQ code. Data is entered externally by interrogating other sources. There is no other way to relate this unambiguously to my data, since there is no “key” as such from an external source for reference. Therefore, in this sense, the value of the timestamp will not be an option. I understand that this method is not "accurate", but I can live with it. I could add the ability to manually view possible hash matches and push them further into the database if they are acceptable.
jaffa source
share