Entity Framework and Encrypted Database

asp.net, c#, encryption, entity-framework, sql-server

Solution

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.

Problem

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

Original source