////////////////
public static void EncryptConnString()
{
string msg="";
Configuration config = WebConfigurationManager.OpenWebConfiguration("~");
ConfigurationSection section = config.GetSection("connectionStrings");
if (!section.SectionInformation.IsProtected)
{
section.SectionInformation.ProtectSection("RsaProtectedConfigurationProvider");
config.Save();
}
///////////// or
Configuration config1 = WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);
ConfigurationSection configSection =
config1.GetSection("connectionStrings");
if (!configSection.SectionInformation.IsProtected)
{
configSection.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");
config1.Save();
msg="ConnectionStrings has been
encryted successfully.";
}
else
{
msg="ConnectionStrings Already
encryteded, this action has been cancled";
}
}
public static void DecryptConnString()
{
string msg = "";
Configuration config = WebConfigurationManager.OpenWebConfiguration("~");
ConfigurationSection section = config.GetSection("connectionStrings");
if (section.SectionInformation.IsProtected)
{
section.SectionInformation.UnprotectSection();
config.Save();
}
///////////////// or
Configuration config1 = WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);
ConfigurationSection configSection =
config1.GetSection("connectionStrings");
if (configSection.SectionInformation.IsProtected)
{
section.SectionInformation.UnprotectSection();
config.Save();
msg = "ConnectionStrings has been
Decrypt successfully.";
}
else
{
msg = "ConnectionStrings Already
Decrypted, this action has been cancled";
}
}
/////////// Result
///////////--------Original
<connectionStrings>
<add name="ConnDB" connectionString="Data Source=Abc;Initial
Catalog= Main;Integrated Security=True;Connect Timeout=500" providerName="System.Data.SqlClient"/>
</connectionStrings>
///////////--------Encrypted
<connectionStrings configProtectionProvider="DataProtectionConfigurationProvider">
<EncryptedData>
<CipherData>
<CipherValue>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAYGhwDVq4A0K6/N1Iz7hkjwQAAAACAAAAAAAQZgAAAAEAACAAAAAQLUts2b81u6QlaWMSfIVR0iBp5su9KGX2i+VpML9lngAAAAAOgAAAAAIAACAAAACkbblBrg5LRH7smCEsfCzed1UAMo3xxqodk5FCFpCjWWADAACbZIl/yzrSLQGte1E4pPf/s3NkdZToUIS5RgXFrNBPXQNLIPEpU/GaVvRuWkc5Yz24ICYDFq2O8nfcuVwr9Jj2Edxh4RZCq8qM0bdlhOVzrouI2uIHxuwOHLEb8Sr366iIeOE0SNQTvRtBGITbjWcUFeZ6Bo/xx5B1YUNvPMnT7Oth9yvmyvD8jEiniuUuV1l6qKFB2hpsQg0lBXTt7prRPZX1TFKnPRhNKOXB08t/I9YMeeJAdh/EYIoEghYEgly6JKWltuw1tEzJyIxHYBxlBAoa/1Z9xVaq9HxQNwwb9BTAgYn56TYimIZd9i1avKYvQIGfRSnwoTdzO0+GAkGOQveH22few/nZNFty75DbepkxjDLt0Ew7DMVXIlPncKmGYa5lKE9eD1k8ZfhX+oarukxKy/XZ3t1POcsdcLhpPGwurAab7VRz/Zn+Ja+nK5J6kPo/VuEtQDtuVbv+GNAX/bFsyoWrzlx4S5DxlUm0pfnjH6bDvxLJUGhZsZBoh6Pnejrst4dAm810clfbYxHmJZDqBtokd3LVVUTaP6UESPxDod1xR7NPXUNwuk4kGlQ5BOx2JYaDGwieaRY937LQMBhacXQa5zmvOaX0DfEwTcwU3p5uOsSD3Mw2F/Enrztewuo12ZuGce7EttmfYb7qCG0pwxGUAvNWwG2U9PQayeWvSEFplomcwJtmoAVU0ZdsqWTcWj7/KoFLO2hQ6XXk0S103LoLzgWbLE4sxlhnOEESYYtCZf9oz2EGF9NTOX5ZZ2/OjgKM+fQJ8ARnsNknvQuJ2vWRpf/56FGw0mRvONf7/2JkP6XGhWOaEp+qrhif5Bg3OzsLq6qxzQ37P1XJwgo9HzrG9zn0YqnttjecCX5mdpRggF5B7oWpKHuMVk/dlIMDQuzpXG9B4Vl2/JxkDjpxkIdWJwZbce/gFE+DQQsKo3QXhcRX85K3RbHDjTOg3pJ8tfyKmqVP85VF538Ca2VE4j66usInzQ1AuAyDe84PnefTGA98rtmFYQE8yiHU71iYGTdjtSPbOF71B8TiazNO4kgtcdHudOOLf4on0Jk0J0AcYtBMXIcKY0VfrDsIs9JkDD4Hsn0Jt+w9meC/akzZegCaF3oQpCSqLyg80xNL+npzFMuLjFobuF5s49pAAAAAVHx94/aTalWw5ZWqlzwxFMnV3Fo2ow7jCGBuo/qqomAxxmQS3zAhfREHlPGZuzKkcASqnuS+XIoFPKWUIePBTQ==</CipherValue>
</CipherData>
</EncryptedData>
</connectionStrings>