[sqlite] INSERT is not committing from c#

[nmartin]

I have a C# from which I am trying to perform a COMMIT. The INSERT does not
throw an error but no data is inserted. I have tried a couple ways of
COMMITTING:

try
        {
            SQLiteTransaction liteTransaction =
Connection.BeginTransaction();
            SQLiteCommand command = new
SQLiteCommand(insert.BuildInsert(tableName, keyValuePairs), Connection);
            command.Transaction = liteTransaction;
            command.ExecuteNonQuery();
            liteTransaction.Commit();
        }
        catch (SQLiteException e)
        {
            //error
            connection.Close();
        }

And Just and Explicit Commit:

INSERT INTO TestData
(deepbreathing,usertechnique,guidedimagery,yoga,exercise,meditation,prayer,somethingelse,howoften,numtechniques,userreturn,chosentechnique,chosentechnique)VALUES
("true","I will try to use deep
breathing.","false","true","false","false","true","true","When I'm
stressed","1","true","deepbreathing","deepbreathing"); COMMIT;


Can anyone helps?
-- 
View this message in context: 
http://old.nabble.com/INSERT-is-not-committing-from-c--tp28891789p28891789.html
Sent from the SQLite mailing list archive at Nabble.com.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users