Script hack to update web.config before build

AzureDevops-UpdateWebConfig.ps1

$server = "127.0.0.1"
$database = "TomatoFarm123"
$username ="use12356"
$password = "pAssWord!"

$connectionString = "Server=$server;Database=$database;User Id=$username;Password=$password;" 

$webConfig = "C:\Code\tomatofarm\Api\Api\Web.Config"
$xml = New-Object xml
$xml.PreserveWhitespace = $true
$xml.Load($webConfig)
$xml.configuration.connectionStrings.add.connectionString = $connectionString
$xml.Save($webConfig)