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

Question

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

You might be able to use the CLR using a SQL Server Database Project and write functions in .NET to be called from SQL, would save you writing it all in SQL. — Lloyd
– Lloyd, Commented Mar 18, 2013 at 10:17
Hi Lloyd, Thanks for replying, can you explain in detail how can I do this?. — rahul aggarwal
– rahul aggarwal, Commented Mar 18, 2013 at 10:23

Remus Rusanu · Accepted Answer · 2013-03-18 10:19:54Z

1

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.

answered Mar 18, 2013 at 10:19

Remus Rusanu

296k42 gold badges459 silver badges583 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related