adolib

1.2

private/Get-Connection.ps1

function Get-Connection{
    param([System.Data.SqlClient.SQLConnection]$conn,
          [string]$server, 
          [string]$database,
          [string]$user,
          [string]$password)
        if (-not $conn){
            if ($server){
                $conn=New-Connection -server $server -database $database -user $user -password $password 
            } else {
                throw "No connection or connection information supplied"
            }
        }
        return $conn
    }