[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.