Re: [sqlite] Semantics regarding command instances and queries in the C# client

2017-04-28 Thread Clemens Ladisch
Joseph L. Casale wrote: > Each row from the CSV required several tables with relationships to be > populated. One could > certainly abstract this out into an api, but that can have impacts on > performance for large > batch processing if you are creating parameters for every insert rather than >

Re: [sqlite] Semantics regarding command instances and queries in the C# client

2017-04-28 Thread Joseph L. Casale
From: sqlite-users on behalf of Clemens Ladisch Sent: Friday, April 28, 2017 2:51 AM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Semantics regarding command instances and queries in the C# client   > Show some example. Hey Clemens, Check out this paste for a qu

Re: [sqlite] Semantics regarding command instances and queries in the C# client

2017-04-28 Thread Clemens Ladisch
Joseph L. Casale wrote: > that practice looks a bit ugly. Show some example. Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Semantics regarding command instances and queries in the C# client

2017-04-27 Thread Joseph L. Casale
Typically I open a connection and a command instance and associate instantiated parameters with the command instances, then process in a loop simply changing parameter values. I have a situation when I am needing to insert and select based on several criteria and that practice looks a bit ugly.