|Title:||Bug in System.Data.SQLite Interop Assembly|
|Last Modified:||2016-06-21 20:17:14|
|Version Found In:||18.104.22.168|
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 22.214.171.124.
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 property. Also, you cannot dispose of a SQLiteCommand and then use it (i.e. indirectly for the SQLiteDataAdapter fill operation).