System.Data.SQLite

Thank you very much. I go now to vacations and I'll impement this after vacations.

Subj. For exampe my table has two fileds RecordID (autoIncrement integer), Name (string) I make such insert ''insert into people  (Name) values (@Name)''; How can I return value of RecordID, of inserted book?

 rsimpson wrote: You don't have to (nor should you) do it that way ... Instead, build the command one time and keep the SQLiteCommand as a member of the class.  (Don't forget to dispose it when your class is no longer needed).  Your code changes to: I think it's much better idea to store commands like static fields and create ...

I want to read int from sqLite. But it returns long on integer values. Should I just make conversion to short int int var = 0; var = (int) dr[''variable'']; Or there is another way?

Thank you!

Just a note. I also have a bunch of queries (such a buffer). By the way. Parametrized insert in loop is two times faster, than insert using bunch of queries. Aleksander Blokha

Yes, I'm sure. I'm using it under Visual Studio 2005 with .net 2.0.  

SQLite.NET ExecuteNonQuery() does not allow CommandText to be more than 110-120 K, it was found out by experimental way. If text is more than 110-120 K it gives exception, ''Attempted to read or write protected memory. This is often an indication that other memory is corrupt.'' If this is not a bug, but feature :), maybe it's a good idea to trow ...

But it seems you have to store not only command, but connection to, because command is executed on connection. And I don't know how to bind existing command to new connection.