CODEWITHSUNDEEP
.netasp.netconfigurationsection
dm7777
dm7777

Reputation: 21

Read settings / sections from the web.config or app.config file

I have many Connection strings in my web.config file. I also have a "dataConfiguration" setting in the same file which specifies what database my app connects to.

How do I read the "defaultDatabase" setting / section from the

Please see below xml file. Many thanks in advance

<configuration>

  <configSections>
  </configSections>

  <appSettings>
  </appSettings>

  <connectionStrings>
   <add name="blablabla"
   <add name="mySQlServerDb"
  </connectionStrings>

  <dataConfiguration defaultDatabase="blablabla/>

</configuration>

Upvotes: 2

Views: 1997

Answers (1)

Daniel Dyson
Daniel Dyson

Reputation: 13230

This is how I have done it in the past:

using System.Configuration;
using Microsoft.Practices.EnterpriseLibrary.Data.Configuration;

DatabaseSettings dbSettings = (DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration");
string connectionString = ConfigurationManager.ConnectionStrings[dbSettings.DefaultDatabase].ConnectionString;

Upvotes: 4

Related Questions