[Mono-list] Sqlite Client

[Ecmel Ercan]

I am using Mono 1.1.10_1 installer on Ubuntu 5.10.  This should be the
latest official release.

using System;
using System.Data;
using Mono.Data.SqliteClient;


public class TestSqlite
{
    public static void Main (string[] args)
    {
        string connString = "version=3,URI=file:test.db";
        SqliteConnection dbcon = new SqliteConnection (connString);
        dbcon.Open ();
		
        SqliteCommand dbcmd = new SqliteCommand (@"
            CREATE TABLE counter1 (
                transid INTEGER
            );

            CREATE TABLE counter2 (
                transid INTEGER
            );

        ");				

        dbcmd.Connection = dbcon;
        dbcmd.ExecuteNonQuery ();
		
         dbcmd.Dispose ();
         dbcon.Close ();
    }
}


This creates only counter1.