- 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.ConnectionStringWrite-Host "Result: $result"