[Mono-list] Sqlite Client

Ecmel Ercan ecmel at ercansoy.com
Tue Nov 29 08:48:30 EST 2005


Hello,

I am trying to use the Mono.Data.SqliteClient with sqlite3 but can not
execute more than one SQL command in a single CommandText:

SqliteCommand dbcmd = new SqliteCommand ();
..
..
dbcmd.CommandText = @"

   CREATE TABLE table1 (
       id TEXT,
       name TEXT
   );

   CREATE TABLE table2 (
       id TEXT,
       name TEXT
   );
";

This command creates table1 only (sometimes).

If it is only possible to use 1 command per SqliteCommand, is it ok to
use only one SqliteCommand instance through out the method?

Best regards.


More information about the Mono-list mailing list