Skip to main content
2 of 3
added sql tag as feel its appropriate
jim tollan
  • 22.5k
  • 4
  • 53
  • 64

Create a simple hash value of database columns using c# .net

I would like to store a simple hash value of n number of columns e.g. address and name, and store the hash in another column. I want to use the hash value as a quick way of synchronising data between 2 sources, by simply comparing the hash value. What is the best way of doing something like this. I don't need crypto functionality just to create the hash.

e.g.

John Smith, 1 Long Lane Road, Village, Town, Postcode. Hash: AK67KS38

I would like the hash value to be simple enough to be readable (not have whole range of Uni-code set).

jaffa
  • 27.5k
  • 51
  • 181
  • 294