Ticket Hash: | 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: | 1.0.99.0 | |||
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 1.0.99.0. The project file is attached to this link. Please go through it. Error details are commented in the code. Thanks 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). |