ConnectionString different for different builds

Question

ConnectionString different for different builds

Navigation

#1 by (8 votes)

7

I have two connection string, one when I'm developing that uses my local bank and another for when I deploy the application in Azure.

I want the application to know which one to use depending on the type of build I do. What is the simplest way to do this?

Do you want to do the connection string level or would I need two different Web.config?

c# entity-framework

asked by anonymous 13.08.2015 / 22:58

1 answer

Preload, prefetch and preconnect, what are they for? Send camera image to server via Retrofit

score 8 · Accepted Answer

The procedure is very similar to this answer here , only to <connectionstrings> . For example:

`Web.Release.config`

<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
    <connectionStrings>
      <add name="DefaultConnection"
        connectionString="MinhaConnectionStringDeProdução"
        xdt:Transform="SetAttributes" xdt:Locator="Match(name)"/>
    </connectionStrings>
</configuration>

`Web.Debug.config`

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