Hi Friends,

I have created two functions that encrypt and decrypt the connection string in web.config. But whenever I want to use connection string using microsoft .net development platform. I have to always decrypt web.config and then again encrypt it back. Does there any other way which i can use.

I'm using section.SectionInformation.ProtectSection(" <encryption configuration provider> ") and section.SectionInformation.UnprotectSection()

 seems that you can either do it in sql server or web.config. It also seems that on matter how you do it, you always have to dance these two steps: encrypt/decrypt, decrypt/encrypt.