From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of Clemens Ladisch <clem...@ladisch.de> 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 quick script quality console app I wrote to help a user consume some data from a collection of csv files into an SQLite database. https://paste.ofcode.org/bFQnrpeQdCkqUES7zfjuZe 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 reusing them. In simple cases, the code is trivial but in this example, it looks terrible given the number of Command instances... Thanks for any opinions, jlc _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users