Entity Framework and Encrypted Database

Question

I have a column (salary) encrypted in database (MS SQL Server). I am using the entity framework to display/edit the records from the front end. Any idea how to decrypt the column in the front end to show the salary value?

Thanks

What type of encryption do you use? MD5? Some encryption types cant be decrypted. — Christian Huber
– Christian Huber, Commented Jul 23, 2012 at 13:06
I am using the TRIPLE_DES ENCRYPTION - blog.sqlauthority.com/2009/04/28/… — Tippu
– Tippu, Commented Jul 23, 2012 at 13:07
I am doing encryption at the database level. Please see the link in my previous comment — Tippu
– Tippu, Commented Jul 23, 2012 at 13:11
So just use a 3DES class that decrypts the data prior to displaying it, you probably know the key since someone must've set it (if not the encryption is useless)... see this link — Shai
– Shai, Commented Jul 23, 2012 at 13:13

Shyju · Accepted Answer · 2012-07-23 13:27:07Z

2

If you are doing encryption on database level you must use database level for decryption - use ObjectContext.ExecuteStoreQuery<YourEntityType>(...) to load records from database - pass SQL command with correct decryption usage into that method.

edited Jul 23, 2012 at 13:27

Shyju

220k106 gold badges421 silver badges499 bronze badges

answered Jul 23, 2012 at 13:25

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

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

1 Comment

Remus Rusanu Over a year ago

... and the correct decryption function is DECRYPTBYKEY

Collectives™ on Stack Overflow

Entity Framework and Encrypted Database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related