Encrypt In .NET / Decrypt in SQL Server

Question

Is there a way to decrypt a column when querying data from a SQL Server (2005/2008) database that has been encrypted using DES via .NET? If so, how? I have the key, but don't know how to use it within the context of a sql server query.

Was the encryption done in C# code and then written to SQL, or was it done using EncryptByKey? You might consider moving to use the built-in SQL encryption /decryption if the former. — Steve Townsend
– Steve Townsend, Commented Oct 22, 2010 at 18:34

Jagmag · Accepted Answer · 2010-10-22 18:31:01Z

3

I would probably consider creating a CLR function in SQL Server to handle this decryption.

You can use this function just like any other UDF within SQL Server to decrypt on demand.

That way, its as simple as using regular .NET C# code to handle it exactly the way you would do it in your application itself.

answered Oct 22, 2010 at 18:31

Jagmag

10.4k1 gold badge37 silver badges60 bronze badges

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

2 Comments

Dathan Over a year ago

Yep, that's how I'd do it. Though, you should carefully consider the use case - is it absolutely necessary to to the decryption in the database, rather than in some service layer? Generally, the fewer times you have to pass the key around, the smaller the vulnerability footprint.

Saraz Over a year ago

No it's health care related info, one way hashing won't do. I was leaning towards putting a service layer over it anyway, so in that case I don't even need to worry about SQL Server.

Collectives™ on Stack Overflow

Encrypt In .NET / Decrypt in SQL Server

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related