Reference connection strings in separate config file

Question

I would like to move my connection strings from my web.config file to a file called ConnectionStrings.config, both files are in the root of my web application.

Web.Config

<configuration>
    <connectionStrings configSource="ConnectionStrings.config"/>
</configuration>

ConnectionStrings.Config

<configuration>
    <connectionStrings>
        <add name="myConnectionString" connectionString="*****" providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>

But when I try and run this I get the following error

The format of a configSource file must be an element containing the name of the section. (C:\Your Application\ConnectionStrings.config line 2)

Any ideas?

Baral · Accepted Answer · 2016-07-22 14:45:00Z

9

Web.Config

 <connectionStrings configSource="ConnectionStrings.config" />

ConnectionStrings.config:

<?xml version="1.0" encoding="utf-8" ?>
<connectionStrings>
    <add name="name" connectionString="server=(local);database=db;user Id=usr;password=pass;timeout=0"></add>
</connectionStrings>

This is how (without the providerName) I do it and it works fine.

answered Jul 22, 2016 at 14:45

Baral

3,1412 gold badges22 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Reference connection strings in separate config file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related