2

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>
Daniel Dyson
  • 13,192
  • 6
  • 42
  • 73
dm7777
  • 21
  • 2

1 Answers1

4

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;
Daniel Dyson
  • 13,192
  • 6
  • 42
  • 73
  • +1 - I was about to break out some code using ConfigurationManager.GetSection, and hadn't spotted that this is actually a config block from the enterprise library. – Rob Levine Jul 09 '10 at 09:31