Change EF database name in connection string tool

change_EF_database.ps1

$files = Get-ChildItem -Include Web.config -recurse | Select-String -pattern 'Database=[a-zA-Z_0-9\-]+;' | select path,matches

if ($files.length -eq 0 )
{
	Write-Host "no files found"	-ForegroundColor red
	exit 0
}

Write-Host "Found the following matches:" -ForegroundColor green

$files | ConvertTo-JSON | Write-Host

$db = Read-host -Prompt "New database name"

Write-Host "Settings database to $($db):" -ForegroundColor green 

 $files | Foreach-Object {$content = Get-Content $_.path; $content | Foreach-Object {$_ -replace 'Database=[a-zA-Z_0-9\-]+;',"Database=$($db);"} | Set-Content $_.path -force }


 Get-ChildItem -Include Web.config -recurse | Select-String -pattern 'Database=[a-zA-Z_0-9\-]+;' | select path,matches| ConvertTo-JSON | Write-Host