PSSQLConn

1.0.2

Private/Get-SqlConnectionString.ps1

Function Get-SqlConnectionString
{
    param(
        [Parameter(ValueFromPipeline=$true)][String]$ServerName
        ,[String]$DatabaseName='TempDB'
        ,$ApplicationName=$null
        ,[String]$UserName
        ,[String]$Password
        ,[Switch]$DoNotPool
        ,[Switch]$TrustServerCertificate
    )
    if($UserName -or $Password){
        $IntegratedSecurity ="FALSE"
    }
    else{
        $IntegratedSecurity ="TRUE"
    }
    $csBuilder = New-Object Microsoft.Data.SqlClient.SqlConnectionStringBuilder `
        -ArgumentList @("Data Source=$ServerName; Initial Catalog=$DatabaseName;")
    $csBuilder["Application Name"]=$ApplicationName
    if($userName){
        $csBuilder["User ID"]=$UserName
    }
    if($password){
        $csBuilder.Password=$Password
    }
    if($DoNotPool.IsPresent)
    {
       $csBuilder.Pooling=$false
    }
    $csBuilder.ToString()
}