Continuous integration TFS/Azure and Connection string in app.config

Question

I have a project composed of two subprojects, one of those subprojects is a Class Library, responsible for database connection activities. I am using Entity Framework as a ORM tool.

In the archive app.config, I have the following string Connection:

<connectionStrings>
        <add name="DB.Context" providerName="System.Data.SqlClient"
             connectionString="Integrated Security=SSPI;Initial Catalog=DB.Context;Data Source=(LocalDb)\v11.0;" />
    </connectionStrings>

Nothing too complex, just points to a local database.

However, at the time of deploying this application for production (by publishing from the Azure version control), I cannot get this string Connection automatically updated to point to the production BD. I have the connection string configured on my panel:

How can I get the connection string present in app.config is updated during publication from TFS in Azure?

Answer 1

This blog shows a step-by-step to Web.config. How transformations apply to all project files if you have installed this extension of Visual Studio has a good chance of working.

Since I didn’t test it, I can’t say 100%.

Answer 2

James,

The app.config does not transform during the deployment - Publishing process (there is how to do this, only via Visual Studio, but is not native until VS2013 version).

Your Connectiostring settings should be in the application, then on the web.config.

This is one of the reasons that there is no transformation in its continuous implementation.