I made Encrypt() and Decrypt() functions to encrypt and decrypt strings and nubbers. I use System.Security.Cryptography.DESCryptoServiceProvider() inside tosecure my data. Now I want to that secured data store to sql server and read from sql server with Entity Framework. I can use
Dim x As New EFModel.Tablex.ColumnName = Encrypt("something")
Dim query = From something In db.StoredProcedure(x1, x2, x3) abc = decrypt(something.something), ...
This is so boring to put in all places, is there some way to somewhere in Entity Framework model put Encrypt and Decrypt functions so apply for every database writing and reading? A want to every data in database be encrypted. Dont ask me why.
View Complete Post