Entity Framework and Encrypted Database

Question

I have a column (salary) encrypted in a database (MS SQL Server). I use an entity structure to display / edit records from the front. Any idea how to decrypt a column in an interface to show the salary value?

thanks

Answer 1

If you use encryption at the database level, you must use the database level for decryption - use ObjectContext.ExecuteStoreQuery<YourEntityType>(...) to load records from the database - pass the SQL command with the correct decryption to this method.