import clr
clr.AddReference("Mono.Data.Sqlite")
import Mono.Data.Sqlite

connection = Mono.Data.Sqlite.SqliteConnection("Data Source=file:database.db")

connection.Open()

cmd = connection.CreateCommand()

cmd.CommandText = """CREATE TABLE employee (
                     firstname varchar(32),
                     lastname varchar(32));"""

reader = cmd.ExecuteReader()


while reader.Read():
    FirstName = reader.GetString(0)
    LastName = reader.GetString (1)
    print(FirstName, LastName)
reader.Close()

cmd.CommandText = """INSERT into employee (firstname, lastname)
                     VALUES ("Firstname", "Lastname");"""

reader = cmd.ExecuteReader()


while reader.Read():
    FirstName = reader.GetString(0)
    LastName = reader.GetString (1)
    print(FirstName, LastName)
reader.Close()

cmd.CommandText = """select * from employee;"""

reader = cmd.ExecuteReader()


while reader.Read():
    FirstName = reader.GetString(0)
    LastName = reader.GetString (1)
    print(FirstName, LastName)
reader.Close()