C#

bulk datatable insert in Sqlite database?

Comments

[Kelly Brown]

Using which library?

[Arunprasath]

System.Data.SQLite library

[Kelly Brown]

I don't know the specifics of that library. I tend to use SQLite raw (direct native calls). You can batch up an insert this way.

INSERT INTO my_table (col1, col2, col3) VALUES
(?, ?, ?),
(?, ?, ?),
(?, ?, ?),
(?, ?, ?),
(?, ?, ?),
(?, ?, ?)

You have to bind all the parameters and then execute it. Are you referring to a literal C# DataTable?