Providers/SQLite/provider.ps1

Class SQLiteProvider : ProviderBase {
    
    SQLiteProvider([string]$ConnectionName
                , [int]$CommandTimeout
                , [System.Data.SQLite.SQLiteConnection]$Connection) {

        $this.ConnectionName = $ConnectionName
        $this.CommandTimeout = $CommandTimeout
        $this.Connection = $Connection
    }

    [string] ProviderType() { return "SQLite" }

    [PSCustomObject] ConnectionInfo() {
        return [PSCustomObject]@{
            ConnectionName = $this.ConnectionName
            ProviderType = $this.ProviderType()
            ConnectionState = $this.Connection.State
            ConnectionString = $this.Connection.ConnectionString
            ServerVersion = $this.Connection.ServerVersion
            DataSource = $this.Connection.DataSource
            CommandTimeout = $this.CommandTimeout
            HasTransaction = $this.HasTransaction()
        }
    }

    [System.Data.DataSet] GetDataSet([System.Data.IDbCommand]$cmd) {
        $ds = [System.Data.DataSet]::new()
        $da = [System.Data.SQLite.SQLiteDataAdapter]::new($cmd)
        Try {
            $da.Fill($ds)
            return $ds 
        }
        Catch { Throw $_ }
        Finally { $da.dispose() }
    }

    [Void] GetMessage() { Write-Warning "SQLiteProvider does not support SqlMessages." }
    [Void] ClearMessages() { Write-Warning "SQLiteProvider does not support SqlMessages." }
}