<connectionStrings>
	<add name="ConnectionName1" connectionString="newstring" providerName="newprovider"
	   xdt:Locator="Condition(@name='oldname' or @providerName='oldprovider')" xdt:Transform="Replace" />
	<add name="ConnectionName2" connectionString="newstring" providerName="newprovider"
       xdt:Locator="Match(name)" xdt:Transform="Replace" />
	<add name="ConnectionName3" connectionString="newstring" providerName="newprovider"
       xdt:Locator="XPath(configuration/connectionStrings[@name='ConnectionName3' 
		or @providerName='System.Data.SqlClient'])" xdt:Transform="Replace" />
</connectionStrings>

Transform Types