System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
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: (text/html)
<div><p>
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.
</p><p>
The project file is attached to this <a href="https://drive.google.com/file/d/0B_czp2rbfZFjU0RxSElxaFFuVEU/view?usp=sharing">link</a>. Please go through it. Error details are commented in the code.
</p><p>
Thanks
</p></div>

mistachkin added on 2016-04-24 08:20:18: (text/x-fossil-plain)
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).