Import/Export CSV from SQLite from C# code

Question

I am trying to figure out an eazy way to load CSV file into SQLite DB using System.Data.SQLite I saw commandline way to do that i.e `.Import mydata.csv mytable` But I need to do this via C# code. Any Idea?

Accepted Answer

you can create `OleDbConnection` to CSV file (just google it, it is very easy) then load rows to DataSet, then put that dataset into Sqlite by `SqliteConnection`. Few lines of code.

Import/Export CSV from SQLite from C# code

Solution

Problem