Read the connectionStrings element of your app.config

Question

I am trying to read connection strings from my app.config, but it shows only one connection string, and this is also not in my app.config.

Here is my code:

System.Diagnostics.Debugger.Break();

Configuration config = 
ConfigurationManager.OpenExeConfiguration(
                    AppDomain.CurrentDomain.SetupInformation.ConfigurationFile);

foreach (var connectionString in config.ConnectionStrings.ConnectionStrings)
    System.Diagnostics.Debug.Print(connectionString.ToString());

And he prints this:

data source=.\SQLEXPRESS;Integrated Security=SSPI;
   AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true

When I expect it to output a custom connectionString to one of my databases, which I specified in the app.config file.

Update

, , , . , ConfigurationManager.ConnectionStrings , , , . , , . . , , .

Answer 1

machine.config. <connectionStrings> app.config <clear/>.

Answer 2

, OpenExeConfiguration, ? app.config, , , , ConfigurationManager.ConnectionStrings.

Answer 3

ConfigurationManager.ConnectionStrings["ConnectionStringName"] , appSetting.

ConfigurationManager.AppSettings["SettingName"]

Answer 4

ConnectionStrings ( app.config), , GetSection() Configuration.

Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
ConnectionStringsSection csSettings = config.GetSection("connectionStrings") as ConnectionStringsSection;
if(csSettings != null)
{
    // examples of removing all settings, adding a new one and removing it
    csSettings.ConnectionStrings.Clear();
    csSettings.ConnectionStrings.Add(new ConnectionStringSettings("myCS", "<connectionString>"));
    csSettings.ConnectionStrings.Remove("myCS");
    // save the changes
    config.Save(ConfigurationSaveMode.Modified);
}

, OpenExeConfiguration (string), , app.config. , OpenMappedExeConfiguration().

Answer 5

( )?

Try:

System.Configuration.ConfigurationManager.AppSettings("MyAppVariable");

, . :

System.Configuration.ConfigurationManager.ConnectionStrings("MyConnectionString").ConnectionString

Answer 6

, ( -). , app.config , , back LocalSqlServer.

.