Fetching Record on Encrypted Column

Dec 9, 2014 at 8:16 AM
Edited Dec 9, 2014 at 8:23 AM

I have a simple requirement where I have to encrypt my User database. SecurEntity works perfectly fine. However, I face problems when I have to fetch a particular user based on one of the encrypted columns.

I did have a look at the sample attached with source code. There the search is based on Thumbprint. If I generate thumbprint on email ID, but if I need to search for a User based on Name (which is also encrypted), how do I do it?

Any answer/solution to this would be very much appreciated. Thanks!

PS: I think this is related to https://securentity.codeplex.com/discussions/547910

Once I do SaveChanges, I cannot get the data unencrypted!