using (DbTransaction trans = connection.BeginTransaction()) { // loop goes here // // loop ends here
trans.Commit(); } Best place to get answers to .NET-related SQLite questions (and more) is at http://sqlite.phxsoftware.com/forums Robert -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of danblack101 Sent: Friday, August 08, 2008 2:01 PM To: sqlite-users@sqlite.org Subject: [sqlite] c# .net beginTrans...where is endtrans? Hi, I have a c# program which has to process a large amount of updates at one time. I have previously used: connection.beginTransaction() commandObject <loop> update SQLite with command object <loop end> commandObject.Transaction.Commit This worked nicely. But now I have modulised my code so that I have a generic updateFunction(String) inside this function I create a commandObject and do the update which is fine, but.... Now I have reached a point where I want to process a large amount of updates therefore need transaction boundaries. So now I have connection.beginTransaction() <loop> updateFunction(String) <loop end> ????How can I commit, I dont have a command object that performs the commit/endTrans, I dont want to commit inside the updateFunction ????? Any help is greatly appreciated Dan -- View this message in context: http://www.nabble.com/c--.net-beginTrans...where-is-endtrans--tp18898927p188 98927.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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users