1 year ago
#262036

johnsabre
How to or where is the reference of the db parameter to its database context column on a DB interceptor method?
The purpose is to intercept queries to and from the database where if a certain column is detected it would encrypt/decrypt the value, for example an SSN column. We're using EF6 with Devart MySQL. I've been able to use the method "ReaderExecuting" DB Interceptor of EF but stuck on what the basis to decide to do the encryption/decryption on the value of a parameter:
As you can see, the command text is there and the collection of parameters, but what should I need to configure in order to connect the parameter to the db context column? And maybe even get the custom attributes set for that column?
c#
database
encryption
entity-framework-6
devart
0 Answers
Your Answer