qaz
qaz

Reputation: 23

multiple elements in web.config - asp.net

Currently my web.config has this:

 <appSettings>
    <add key="UserName" />
    <add key="DBServer" />
    <add key="DBUserName" />
    <add key="DBPwd" />
    <add key="DB" />
  </appSettings>

If i have to connect to multiple db's I would like my web.config to have the following

<appSettings>
    <add key="UserName" />
    <add key="DBServer" />
    <add key="DBUserName" />
    <add key="DBPwd" />
    <add key="DB" />
  </appSettings>

<!--This section needs to hold data for another db server -->
 <appSettings>
    <add key="UserName" />
    <add key="DBServer" />
    <add key="DBUserName" />
    <add key="DBPwd" />
    <add key="DB" />
  </appSettings>

The key names should be the same. Or is having multiple connection string sections the way to go?

Upvotes: 2

Views: 247

Answers (1)

Nick Craver
Nick Craver

Reputation: 630349

You should use the <connectionStrings> section for this, it's exactly what it was designed to do :)

You can find more resources on MSDN for how to access your connection strings in this section.

Upvotes: 5

Related Questions