Sqlite

[DimPrawn]

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.

 

[ScotsPine]

is the syntax

is the syntax

not the same as mssql? separate commands with a semicolon? does it not support stored procs?

 

[ScotsPine]

right -

right -

no stored procs.

 

[DimPrawn]

Re: right -

Re: right -

Found it's a bug in the ADO.NET provider.

Yes SQL should be separated by semi-colons.

Provider is returning the result of the 1st command in the batch and not the last.

Hence UPDATE followed by SELECT does not work.

Still, the src for the provider is available so I can patch the C# code until it is fixed. That's the great thing about open source, you can see and patch the source.

 

[AtW]

sql

sql

> tell me how to include more than one SQL statement in a command?

I written my layer that was splitting multiple SQL statements and executing them one after another.