- string EncryptionKey = "XYZQWER274";
- byte[] clearBytes = Encoding.Unicode.GetBytes(clearText);
- using (Aes encryptor = Aes.Create())
- {
- Rfc2898DeriveBytes pdb = new Rfc2898DeriveBytes(EncryptionKey, new byte[] { 0x49, 0x76, 0x61, 0x6e, 0x20, 0x4d, 0x65, 0x64, 0x76, 0x65, 0x64, 0x65, 0x76 });
- encryptor.Key = pdb.GetBytes(32);
- encryptor.IV = pdb.GetBytes(16);
- using (MemoryStream ms = new MemoryStream())
- {
- using (CryptoStream cs = new CryptoStream(ms, encryptor.CreateEncryptor(), CryptoStreamMode.Write))
- {
- cs.Write(clearBytes, 0, clearBytes.Length);
- cs.Close();
- }
- clearText = Convert.ToBase64String(ms.ToArray());
- }
- }
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.