View Ticket
Not logged in
Ticket UUID: 2747b8a677ae2057a5617df1e20684256d6bbc93
Title: Bug in System.Data.SQLite Interop Assembly
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Connection Resolution: Works_As_Designed
Last Modified: 2016-06-21 20:17:14
Version Found In:
User Comments:
anonymous added on 2016-04-23 09:16:16:

Recently wrote a generalized code in C#.Net to handling databases. So far it works fine for MS SQL & MySQL but when I try to use SQLite I keep getting the error in Data Fill to Datatable. I am using VS 2010, .Net framework 4 and System.Data.SQLite

The project file is attached to this link. Please go through it. Error details are commented in the code.


mistachkin added on 2016-04-24 08:20:18:
The error you describe appears to be caused by the database file not being
present in combination with using the "FailIfMissing" connection string

Also, you cannot dispose of a SQLiteCommand and then use it (i.e. indirectly
for the SQLiteDataAdapter fill operation).