Hi,

I would like to get some information on Encryption using Public/Private Key. Appreciate if someone could help me with the following:


1. When a client sends me the Public/Private Key Certificate how can I store this in my SQL Server database for later use in encrypting sensitive data?

2. If my client has got a certificate, is it possible for them to send me the public key only to me so that I could save it in my database instead of the certificate? Also, Can I store the Public Key as “varchar” in my database?

3. How can I encrypt for example, client’s credit card number with the public key for the above scenarios? Appreciate if someone could provide me a code snippet.

4. Can you please let me know the best way to manage encryption? Is it better to have them send the public key only or store the certificate?

I’m using SQL Server and C#.


Thanks & Regards!