- Published on
Build SQL connection string in powershell
- Authors
- Name
- Jeevan Wijerathna
- @iamjeevanvj
Problem
Build SQL connection string in powershell
Solution
$Server = "localhost" $Database = "TestDB" $UserName = "user" $Password = "@Passpowrd" $builder = [System.Data.SqlClient.SqlConnectionStringBuilder]::new() $builder.Server = $Server $builder.Database = $Database $builder.'User ID' = $UserName $builder.Password = $Password $result = $builder.ConnectionString Write-Host "Result: $result"