[Mono-list] Sqlite Client

[Kamil Skalski]

I remember having the same problem with mono svn. I just used the same
command multiple times to execute each query element.

2005/11/29, Ecmel Ercan <ecmel at ercansoy.com>:
> 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.
>
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
>
>


--
Kamil Skalski
http://nazgul.omega.pl