Anyone used the .NET provider sourceforge.net/projects/adodotnetsqlite/ for the embedded Sqlite database www.sqlite.org/ tell me how to include more than one SQL statement in a command?
For example, set the CommandText to perform an insert and also select the last_insert_rowid() so that this is available using ExecuteScalar()?
I have got round it by running two commands on the same connection, but someone must know how to run SQL batches through a single command?
By the way this free lightweight DB engine is pretty good.
For example, set the CommandText to perform an insert and also select the last_insert_rowid() so that this is available using ExecuteScalar()?
I have got round it by running two commands on the same connection, but someone must know how to run SQL batches through a single command?
By the way this free lightweight DB engine is pretty good.
Comment