Is it possible to have mail addresses encrypted in the ApplicationServices database?

Question

For added security, for storing email addresses private in the project I'm working on, I would like all emails stored in our database to be encrypted. However, we use the Asp.Net membership provider, and emails are displayed in clear text in the Email column of the aspnet_Membership table. Their way to achieve this? Ideally, an easy way.

Answer 1

I would create a custom provider and just add a little code to encrypt the email address.

they released a source for an ASP.net provider

http://weblogs.asp.net/scottgu/archive/2006/04/13/442772.aspx

ProviderToolkitSamples.msi

SQLMembershipProvider.cs 366, , .

.

. , , .

http://hectorcorrea.com/blog/Encrypt-and-Decrypt-a-string-in-C-Sharp

, !