TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Ruchi Sharavat
NA
959
600.8k
Same encryption Description for C# and SQL
May 9 2021 3:27 AM
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.
Reply
Answers (
4
)
This returns 0 but i expected 9
How to load partial page in the same page using button in asp.net mvc