SQLITE - INSERT does not return error but no data is inserted.
- by Nick
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();