/// <summary>
/// Get param value from connectionstring section
/// </summary>
/// <param name="paramName">Connection name</param>
/// <param name="informationType">Connection information type to return</param>
/// <returns>Value of indicated type from selected connection string on connectionstring node</returns>
public static string GetFromConnectionString(string paramName, ConnectionStringInformationType informationType)
{
try
{
var connection = WebConfigurationManager.ConnectionStrings[paramName];
if (connection == null)
{
return(null);
}
switch (informationType)
{
case ConnectionStringInformationType.ConnectionString:
return(connection.ConnectionString);
case ConnectionStringInformationType.Name:
return(connection.Name);
case ConnectionStringInformationType.ProviderName:
return(connection.ProviderName);
}
return(null);
}
catch (Exception e)
{
Debug.WriteLine(e);
return(null);
}
}
/// <summary>
/// Modify a connection string value on connectionstring section
/// </summary>
/// <param name="paramName">Connection name</param>
/// <param name="informationType">Connection information type to modify value</param>
/// <param name="paramValue">New value for information type on connection string</param>
/// <returns>Operation result</returns>
public static bool SetToConnectionString(string paramName, ConnectionStringInformationType informationType, string paramValue)
{
try
{
var configuration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
if (configuration.ConnectionStrings == null)
{
return(false);
}
if (configuration.ConnectionStrings.ConnectionStrings[paramName] == null)
{
return(false);
}
switch (informationType)
{
case ConnectionStringInformationType.ConnectionString:
configuration.ConnectionStrings.ConnectionStrings[paramName].ConnectionString = paramValue;
break;
case ConnectionStringInformationType.Name:
configuration.ConnectionStrings.ConnectionStrings[paramName].Name = paramValue;
break;
case ConnectionStringInformationType.ProviderName:
configuration.ConnectionStrings.ConnectionStrings[paramName].ProviderName = paramValue;
break;
}
configuration.Save();
ConfigurationManager.RefreshSection("connectionStrings");
return(true);
}
catch (Exception e)
{
Debug.WriteLine(e);
return(false);
}
}
