Close-Connection

DBSystems: Closes an existing SimplySQL database connection

Script

#Requires -Version 5.0
#Requires -Modules SimplySQL

[CmdLetBinding()]
Param(
    [string]$ConnectionName = "DefaultConnection"
)

Import-Module SimplySQL

try {
    $status = "Connection '$ConnectionName' not found or already closed."
    if (Test-SqlConnection -ConnectionName $ConnectionName) {
        Close-SqlConnection -ConnectionName $ConnectionName 
        $status = "Connection '$ConnectionName' successfully closed."
    }
    
    Write-Output $status
} catch {
    throw
}

Customize

ConnectionName string

Specifies the name of the connection to close (Defaults to 'DefaultConnection')