You are designing an ASP.NET Web application in Microsoft Visual Studio 2010. You plan to deploy the application to multiple branch offices within your company.
Each branch office requires different settings for SQL Server connections.
You need to centrally manage the automatic configuration for each branch deployment.
Which two approaches could you recommend?
(Each correct answer presents a complete solution. Choose two.)

A.
Use a separate web.config file for each branch office.

B.
Store the connection strings in the database

C.
Use configuration transformations.

D.
Use MSDeploy.