C#: Importing a large csv file into a SQLite DB. How to do it?

Question

SQLite

Please tell me a good way to migrate big data (1M rows, 12 columns) from csv file to SQLite database (without resorting to loop iterations, slow and inefficient).

Answer 1

https://www.bricelam.net/2017/07/20/sqlite-bulk-in... .
https://stackoverflow.com/questions/364017/faster-...
Install pragmas

synchronous = OFF + locking_mode = EXCLUSIVE + journal_mode = OFF

And use a batch insert of 50,000 items

Answer 2

Try the sqlite console utility (Gui may hang):

sqlite> create table mytable(a, b);
sqlite> .mode csv
sqlite> .import myfile.csv mytable