Skip to content

Instantly share code, notes, and snippets.

@Dynyx
Created June 4, 2012 13:19
Show Gist options
  • Save Dynyx/2868320 to your computer and use it in GitHub Desktop.
Save Dynyx/2868320 to your computer and use it in GitHub Desktop.
Encrypt connection string in web.config
public static class EncryptConnection
{
public static void EncryptConnectionString(bool encrypt)
{
Configuration configFile = null;
try
{
// Open the configuration file and retrieve the connectionStrings section.
configFile = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
ConnectionStringsSection configSection = configFile.GetSection("connectionStrings") as ConnectionStringsSection;
if ((!(configSection.ElementInformation.IsLocked)) && (!(configSection.SectionInformation.IsLocked)))
{
if (encrypt && !configSection.SectionInformation.IsProtected)//encrypt is false to unencrypt
{
configSection.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");
}
if (!encrypt && configSection.SectionInformation.IsProtected)//encrypt is true so encrypt
{
configSection.SectionInformation.UnprotectSection();
}
//re-save the configuration file section
configSection.SectionInformation.ForceSave = true;
// Save the current configuration.
configFile.Save();
}
}
catch (System.Exception ex)
{
throw (ex);
}
finally
{
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment