Arunprasath Posted on Jul 11, 2019 C# #csharp bulk datatable insert in Sqlite database? Top comments (3) Subscribe Submit Preview Dismiss Collapse Expand Kelly Brown Kelly Brown Kelly Brown Follow C# game dev Location USA Work Software Engineer Joined Jul 9, 2019 • Jul 11 '19 Dropdown menu Copy link Hide Using which library? Collapse Expand Arunprasath Arunprasath Arunprasath Follow Location Chennai Work Full stack Joined Jul 10, 2019 • Jul 11 '19 Dropdown menu Copy link Hide System.Data.SQLite library Collapse Expand Kelly Brown Kelly Brown Kelly Brown Follow C# game dev Location USA Work Software Engineer Joined Jul 9, 2019 • Jul 11 '19 Dropdown menu Copy link Hide 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? Code of Conduct • Report abuse
Top comments (3)
Using which library?
System.Data.SQLite library
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.
You have to bind all the parameters and then execute it. Are you referring to a literal C#
DataTable?