CODEWITHSUNDEEP
asp.netsql-serverencryption
rahul aggarwal
rahul aggarwal

Reputation: 143

Implement same Encryption and Decryption Technique in SQL Server as implemented in ASP.Net

I created two methods Encrypt() and Decrypt() in my Web Application for Encrypting and Decrypting Data.

Now, I want to use same technique in my SQL Server Database for Decrypting Data.

Can anyone tell me how is it possible.

Please help!!

Thanks, Rahul

Upvotes: 0

Views: 122

Answers (1)

Remus Rusanu
Remus Rusanu

Reputation: 294267

Even though is theoretically possible to load your functions as SQLCLR, you will get key management wrong. Use SQL Server cryptographic functions and discard everything you wrote yourself. Use a proper key hierarchy.

Upvotes: 1

Related Questions