[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