So are you saying you are just reading data from your SQLite db using C# and just need to insert using the SQLite command?
-----Original Message----- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Chris Prakoso Sent: Tuesday, February 9, 2016 7:56 AM To: SQLite mailing list Subject: Re: [sqlite] C# + SQLite - Update/Insert using Transaction is slower than without. Steven, I don't use any back-end, the code I pasted here IS my back-end. I opted for direct SQLite connection. So I don't use EF6 nor Linq. Chris On Tue, Feb 9, 2016 at 1:47 PM, Steven M. McNeese < steven.mcneese at freedomparkdfw.com> wrote: > Chris, > > What are you using in c# for SQLite back end? Ado.net? Linq. Let me > know and I can help you with bulk inserts. > > Sent from my iPhone > > > On Feb 9, 2016, at 6:13 AM, Chris Prakoso <chris at prakoso.net> wrote: > > > > Ok. Got it. > > Now, if only I can get that multiple rows update working on my code, > > it would be perfect. > > > > Thanks a lot, > > Chris > > > >> On Tue, Feb 9, 2016 at 12:07 PM, Clemens Ladisch > >> <clemens at ladisch.de> > wrote: > >> > >> Chris Prakoso wrote: > >>> public bool UpdateData(string tableName, > >> Dictionary<string,object> fields, List<string> whereKeys) > >>> { > >>> ... > >>> using (SQLiteTransaction transaction = > >> conn.BeginTransaction()) > >>> { > >>> ... > >>> rowsUpdated = cmd.ExecuteNonQuery(); > >>> transaction.Commit(); > >> > >> Using one transaction for each statement is slow. > >> (Re-opening the database doesn't help either.) > >> > >> You should use a single transaction around all update statements. > >> > >> > >> Regards, > >> Clemens > >> _______________________________________________ > >> sqlite-users mailing list > >> sqlite-users at mailinglists.sqlite.org > >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-user > >> s > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
