Get multiple connection strings from web.config

Question

How to get all connection string names from web.config through code in C #?

I tried this:

System.Configuration.Configuration webConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~"); ConnectionStringsSection x = webConfig.ConnectionStrings; string here = x.SectionInformation.Name; 

Answer 1

  foreach (ConnectionStringSettings c in System.Configuration.ConfigurationManager.ConnectionStrings) { //use c.Name } 

Answer 2

Not defined for connection strings, but may be useful nonetheless.

 System.Web.HttpContext ctx = System.Web.HttpContext.Current; Configuration config; if (ctx != null) config = WebConfigurationManager.OpenWebConfiguration(ctx.Request.ApplicationPath); 

Answer 3

Here's how to use LINQ to get a list of connection string names:

 List<string> names = ConfigurationManager.ConnectionStrings .Cast<ConnectionStringSettings>() .Select(v => v.Name) .ToList(); 

Or you can build his dictionary:

 Dictionary<string/*name*/, string/*connectionString*/> keyValue = ConfigurationManager.ConnectionStrings .Cast<ConnectionStringSettings>() .ToDictionary(v => v.Name, v => v.ConnectionString);