-
Notifications
You must be signed in to change notification settings - Fork 0
/
Close-SqlConnection.ps1
39 lines (35 loc) · 1 KB
/
Close-SqlConnection.ps1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<#
.SYNOPSIS
SQL Connection should be closed if no longer required.
.DESCRIPTION
SQL Connection should be closed if no longer required.
.PARAMETER Connection
Required. System.Data.SqlClient.SqlConnection Object
.OUTPUTS
Close SQL Connection
.EXAMPLE
Close-SqlConnection -Connection $sqlConnection
#>
function Close-SqlConnection() {
[cmdletbinding()]
Param (
[Parameter(Mandatory = $true, Position = 0)]
[System.Data.SqlClient.SqlConnection]$Connection
)
Begin {
}
Process {
try {
#SQL Connection should be closed once the whole XML has been processed.
$isOpenConnection = ($Connection.State -eq [System.Data.ConnectionState]'Open')
if ($isOpenConnection) {
$Connection.Close()
}
}
catch {
Write-Exception -ErrorObj $_ -Message "Throws an exception in 'Close-SqlConnection'" -Stop $true
}
}
End {
}
}