Code Snippets

C# Source Code

Welcome to Dream.In.Code
	Become a C# Expert! Join 340,125 C# Programmers for FREE! Get instant access to thousands of C# experts, tutorials, code snippets, and more! There are 4,048 people online right now. Registration is fast and FREE... Join Now! Chat LIVE With a C# Expert

Secure the connectionStrings section of app.config file

This is a snippet I use to determine the encryption status of the connectionStrings section of the app.config file. If the section is already encrypted I remove the encryption so I can get the connection string, otherwise I encrypt it because I'm finished

Submitted By: PsychoCoder

Actions:

Rating:

Views: 5,656

Language: C#

Last Modified: November 8, 2008

Instructions: Add System.Configuration as a Reference then add using System.Configuration to the top of your class.

Pass the name of the application you wish the check (like "MyApplication.exe")

Snippet

/// <summary>
/// method for encrypting/decrypting the connectionString section of the
/// app.config file
/// </summary>
/// <param name="appName">the name of the application
///</param>
public bool CheckConnStringSectionStatus(string appName)
{
try
{
// Open the configuration file and retrieve the connectionStrings section.
Configuration configFile = ConfigurationManager.OpenExeConfiguration(appName);
//get the section we wish to work with (in this case the connectionStrings section
ConnectionStringsSection configSection = configFile.GetSection("connectionStrings") as ConnectionStringsSection;
//check to see if the section is already encrypted
if (configSection.SectionInformation.IsProtected)
{
//it is so we need to remove the encryption
configSection.SectionInformation.UnprotectSection();
}
else
{
//not encrypted so we need to encrypt it
configSection.SectionInformation.ProtectSection("RSAProtectedConfigurationProvider");
}
//re-save the configuration file
configFile.Save(ConfigurationSaveMode.Full, true);
//return true since we were successful
return true;
}
catch (Exception ex)
{
//return false since we failed
return false;
}
}

Copy & Paste

/// <summary>
/// method for encrypting/decrypting the connectionString section of the
/// app.config file
/// </summary>
/// <param name="appName">the name of the application
///</param>
public bool CheckConnStringSectionStatus(string appName)
{
    try
    {
        // Open the configuration file and retrieve the connectionStrings section.
        Configuration configFile = ConfigurationManager.OpenExeConfiguration(appName);

//get the section we wish to work with (in this case the connectionStrings section
        ConnectionStringsSection configSection = configFile.GetSection("connectionStrings") as ConnectionStringsSection;

//check to see if the section is already encrypted
        if (configSection.SectionInformation.IsProtected)
        {
            //it is so we need to remove the encryption
            configSection.SectionInformation.UnprotectSection();
        }
        else
        {
            //not encrypted so we need to encrypt it
            configSection.SectionInformation.ProtectSection("RSAProtectedConfigurationProvider");
        }

//re-save the configuration file
        configFile.Save(ConfigurationSaveMode.Full, true);

//return true since we were successful
        return true;
    }
    catch (Exception ex)
    {

//return false since we failed
        return false;
    }
}