How do I use Web.Config transform on my connection strings?

by

This works for me but I too have found it to be a bit flakey at times.
You will need to create another file called Web.Config.Release and fill it with the following:

<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">

  <connectionStrings>
    <add name="local" connectionString="Data Source=IPAddress,Port;Initial Catalog=SomeOtherDB;User ID=TopSecretUsername;Password=SecurePassword" 
    xdt:Transform="SetAttributes" xdt:Locator="Match(name)"/>
  </connectionStrings>

  <system.web>
    <compilation xdt:Transform="RemoveAttributes(debug)" />

  </system.web>
    <appSettings>
        <add key="default_db_connection" value="local" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    </appSettings>
</configuration>

More Related Contents:

  1. Read connection string from web.config
  2. How to set web.config file to show full error message
  3. Login failed for user ‘IIS APPPOOL\ASP.NET v4.0’
  4. Why is JsonRequestBehavior needed?
  5. How do I enable HTTP PUT and DELETE for ASP.NET MVC in IIS?
  6. SQL Express connection string: mdf file location relative to application location
  7. Passing data between different controller action methods
  8. MVC3 Razor DropDownListFor Enums
  9. Redirect From Action Filter Attribute
  10. How to render a Razor View to a string in ASP.NET MVC 3?
  11. Restrict access to a specific controller by IP address in ASP.NET MVC Beta
  12. Generic method multiple (OR) type constraint
  13. Web.Config Debug/Release
  14. Variables within app.config/web.config
  15. ASP.NET MVC DropDownListFor with model of type List
  16. How do I define a method in Razor?
  17. GET and POST methods with the same Action name in the same Controller [duplicate]
  18. request exceeds the configured maxQueryStringLength when using [Authorize]
  19. How do you clear cookies using asp.net mvc 3 and c#?
  20. MaxLength Attribute not generating client-side validation attributes
  21. Place to put Database.SetInitializer
  22. Possible to access MVC ViewBag object from Javascript file?
  23. Encrypting Web.Config
  24. Get ConnectionString from appsettings.json instead of being hardcoded in .NET Core 2.0 App
  25. Conditionally change CSS class in Razor view
  26. Model Binding to Enums in ASP.NET MVC 3
  27. How does DataAnnotations really work in MVC?
  28. Uploading image in ASP.NET MVC
  29. The ObjectContext instance has been disposed and can no longer be used for operations that require a connection [duplicate]
  30. MVC Form Validation on Multiple Fields

Leave a Comment