How to get all the connection strings's names from the web.config via code in C#?
I tried this:
System.Configuration.Configuration webConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~");
ConnectionStringsSection x = webConfig.ConnectionStrings;
string here = x.SectionInformation.Name;
foreach (ConnectionStringSettings c in System.Configuration.ConfigurationManager.ConnectionStrings)
{
//use c.Name
}
System.Configuration.ConfigurationManager.ConnectionStrings at MSDN.
This is how to use LINQ to get list of connection string names:
List<string> names = ConfigurationManager.ConnectionStrings
.Cast<ConnectionStringSettings>()
.Select(v => v.Name)
.ToList();
Or you can build a dictionary of it:
Dictionary<string/*name*/, string/*connectionString*/> keyValue = ConfigurationManager.ConnectionStrings
.Cast<ConnectionStringSettings>()
.ToDictionary(v => v.Name, v => v.ConnectionString);
Not specific to Connection Strings, but might be helpful none the less.
System.Web.HttpContext ctx = System.Web.HttpContext.Current;
Configuration config;
if (ctx != null)
config = WebConfigurationManager.OpenWebConfiguration(ctx.Request.ApplicationPath);
