How to change connectionstring for Home and Office ?

preno 60

I need to use a different connecton strings to my developmente DB when I work at home than the one used at Office. I also need different connection string for deployment. For now I simply comment the rows in the web.config each time.

Is there an easy way to do this?

I thought at conditional compilation symbols, but i don't know if is a good way.

Thanks.

Lan Huang-MSFT 28,841 Reputation points Microsoft Vendor

2023-05-17T03:26:16.8+00:00
Hi @preno,

You can try using the Web.config transform, which automates the process of changing Web.config file settings.

A Web.config transformation file contains XML markup that specifies how to change the Web.config file when it is deployed. You can specify different changes for specific build configurations and for specific publish profiles. The default build configurations are Debug and Release, and you can create custom build configurations.

https://learn.microsoft.com/en-us/previous-versions/aspnet/dd465326(v=vs.110)?redirectedfrom=MSDN

There are xdt:Transform and xdt:Locator attributes that we use in the Web.Config file.

<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform"> <connectionStrings> <add name="DefaultConnection" providerName="System.Data.SqlClient" connectionString="****" xdt:Transform="SetAttributes" xdt:Locator="Match(name)"/> </connectionStrings> </configuration>

Share via

How to change connectionstring for Home and Office ?