Our requirement: We need to encrypt the table records (i.e.) field values using 3DES algorithm.
For that, we got the attached code from MSDN site and working fine. But we have the following 2 questions.
Question 1: If we BACKUP & RESTORE the same database, the decryption is not working for old / existing records. But the new records (i.e. records created after restore) are working fine. But we need to decrypt the old records also. --- HOW?
Question 2: Suppose the master database or master key DAMAGED / LOST, how can we get the same key and decryption for old recods.... HOW?
We need solution for these 2 questions.
If you have any other better logic for encryption / decryption other than the attached code, please let us know, we will follow that logic.
We are developing code in ASP.NET C#3.5 & MS SQL 2008 R2