You are preparing to deploy an ASP.NET application to a production server by publishing the
application in Release configuration. You need to ensure that the connection string value that is
stored in the web.config file is updated to the production server’s connection string value during
publishing. What should you do?

A.
Add the following code to the web.config file.
<connectionStrings>
<add name=”DB”connectionString=”Server=ProdServer;Database=ProdDB;Integrated
Security=SSPI;”providerName=”Release” />
</connectionStrings>

B.
Add the following code to the web.config file.
<connectionStrings>
<add name=”DB”connectionString=”Server=ProdServer;Database=ProdDB;Integrated
Security=SSPI;” xdt:Transform=”Replace” xdt:Locator=”Match(name)” />
</connectionStrings>

C.
Add the following code to the web.release.config file.
<connectionStrings>
<add name=”DB”connectionString=”Server=ProdServer;Database=ProdDB;Integrated

Security=SSPI;”providerName=”Release” />
</connectionStrings>

D.
Add the following code to the web.release.config file.
<connectionStrings>
<add name=”DB”connectionString=”Server=ProdServer;Database=ProdDB;Integrated
Security=SSPI;” xdt:Transform=”Replace” xdt:Locator=”Match(name)” />
</connectionStrings>