Disconnect-SQLite.ps1
|
Function Disconnect-SQLite { <# .SYNOPSIS Disconnects from database file .DESCRIPTION Disconnects from database file and disposes connection. .INPUTS SQLiteConnection .EXAMPLE PS C:\> Disconnect-SQLite <System.Data.SQLite.SQLiteConnection> .EXAMPLE PS C:\> Disconnect-SQLite -Connection <System.Data.SQLite.SQLiteConnection> -Dispose Close the connection and disposes the object. .EXAMPLE PS C:\> <SQLiteConnection> | Disconnect-SQLite .NOTES Author: Proxx Web: www.Proxx.nl Date: 10-06-2015 .LINK http://www.proxx.nl/Wiki/Disconnect-SQLite #> [cmdletbinding(SupportsShouldProcess=$true)] Param( [Parameter( Mandatory=$true, ValueFromPipeline=$true, Position=0 )] [System.Data.SQLite.SQLiteConnection]$Connection, [Switch]$Dispose ) $Location = $Connection.ConnectionString.Replace("Data Source = ","") if ($Connection.State -eq 'Open') { if ($PSCmdlet.ShouldProcess($Location, "Close")) { $Connection.Close() } } if ($Dispose) { if ($PSCmdlet.ShouldProcess($Location, "Dispose")) { $Connection.Dispose() } } } |