SQLITE - INSERT does not return error but no data is inserted.

Posted by Nick on Stack Overflow See other posts from Stack Overflow or by Nick
Published on 2010-06-14T20:45:34Z Indexed on 2010/06/14 20:52 UTC
Read the original article Hit count: 183

Filed under:
|
|

I am attempting to insert data into a local SQLITE database file from a C# application. The transaction does not throw any errors but the data is not inserted. The same insert statement works from within a query analyzer.

Do I need to perform a commit? Is there a Commit method?

Command's transaction property is null..

  var command = new SQLiteCommand(insert.BuildInsert(tableName,keyValuePairs),Connection);

            command.ExecuteNonQuery();

© Stack Overflow or respective owner

Related posts about c#

Related posts about database