Ruchi Sharavat

Ruchi Sharavat

  • NA
  • 959
  • 600.8k

Same encryption Description for C# and SQL

May 9 2021 3:27 AM
  1. string EncryptionKey = "XYZQWER274";  
  2.            byte[] clearBytes = Encoding.Unicode.GetBytes(clearText);  
  3.            using (Aes encryptor = Aes.Create())  
  4.            {  
  5.                Rfc2898DeriveBytes pdb = new Rfc2898DeriveBytes(EncryptionKey, new byte[] { 0x49, 0x76, 0x61, 0x6e, 0x20, 0x4d, 0x65, 0x64, 0x76, 0x65, 0x64, 0x65, 0x76 });  
  6.                encryptor.Key = pdb.GetBytes(32);  
  7.                encryptor.IV = pdb.GetBytes(16);  
  8.                using (MemoryStream ms = new MemoryStream())  
  9.                {  
  10.                    using (CryptoStream cs = new CryptoStream(ms, encryptor.CreateEncryptor(), CryptoStreamMode.Write))  
  11.                    {  
  12.                        cs.Write(clearBytes, 0, clearBytes.Length);  
  13.                        cs.Close();  
  14.                    }  
  15.                    clearText = Convert.ToBase64String(ms.ToArray());  
  16.                }  
  17.            }  
I need to send some encrypted url to users somwtimes from C# application and sometime from SQl email functionality.
 
Then will have to create C# page for that url where i need to decrypt querystring. I am using above encryption method for C# encryption. What can i do in SQL to work exactly similar to this so that the decrypt method may work properly for url wheather is it encrypted via SQL or via C#.
 
 
I had tried ENcryptedByKey in sql but that doesn't work to match exactly. 
 
 

Answers (4)