PS> Add-Type -Path "C:\Program Files\System.Data.SQLite\2010\bin\System.Data.SQLite.dll"
PS> $con = New-Object -TypeName System.Data.SQLite.SQLiteConnection
PS> $con.ConnectionString = "Data Source=C:\database\test.db"
PS> $con.Open()
Creating a query
PS> $sql = $con.CreateCommand()
PS> $sql.CommandText = "SELECT * FROM test"
PS> $adapter = New-Object -TypeName System.Data.SQLite.SQLiteDataAdapter $sql
PS> $data = New-Object System.Data.DataSet
PS> [void]$adapter.Fill($data)
PS> $data.tables.rows
PS> $data.tables.rows[0].message
Inserting data
PS> $sql = $con.CreateCommand()
PS> $sql.CommandText = "INSERT INTO test (id, message) VALUES (@id, @message)"
PS> $sql.Parameters.AddWithValue("@id", 3);
PS> $sql.Parameters.AddWithValue("@message", "Some more testing");
PS> $sql.ExecuteNonQuery()
Conclusion
PS> $sql.Dispose()
PS> $con.Close()
