[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