Set-ConnectionStringDatabase for Package Manager Console - updates database name in connection string across all projects in solution

ConnectionStrings.psm1

 function Set-ConnectionStringDatabase {
	 Param(
        [string]$DatabaseName,
        [string]$ConnectionStringName='DBConnectionString'        
    )

    Function Set-ConnectionString{
		Param(
	        [string]$ConfigFile,
	        [string]$ConnectionStringName,
	        [string]$DatabaseName
	    )
		
		[xml] $config = Get-Content $ConfigFile | Out-String
	    $connStringElement = $config.SelectSingleNode("//connectionStrings/add[@name='$ConnectionStringName']")
	    
	    if($connStringElement) {
	       	$connStringElement.connectionString = $connStringElement.connectionString -Replace "database=[\w\-]+|initial catalog=[\w\-]+", "DATABASE=${DatabaseName}"
	      	
	      	# Set up formatting
			$xwSettings = new-object System.Xml.XmlWriterSettings
			$xwSettings.indent = $true
	  		$xmlWriter = [Xml.XmlWriter]::Create($ConfigFile, $xwSettings)
	       	
			$config.Save($xmlWriter)
	    	Write-Host "Updated connection string '$ConnectionStringName' in $ConfigFile"
	    }
	}

	Get-Project -All | ForEach-Object -Process {
		$currentFolder = (Split-Path $_.FullName)
		$file = "${currentFolder}\web.config"
	
		If (!(Test-Path $file)){
			$file = "${currentFolder}\app.config"
		}
 		
 		If (Test-Path $file){
			Set-ConnectionString -ConfigFile $file -ConnectionStringName $ConnectionStringName -DatabaseName $DatabaseName
		}
	}
 }