System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
Ticket Hash: ab3565a7cc007dc085b7bd9ffe753c8314e0e213
Title: Boolean DataReader Cast Error
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Data_Reader Resolution: Works_As_Designed
Last Modified: 2019-12-08 19:11:23
Version Found In: 1.0.112
User Comments:
anonymous added on 2019-11-20 03:43:04:
For Boolean Field, Sqlite Support True/False and 0/1.

If i use True/False,SQLiteDataReader.GetBoolean will throw exception.

I have a solution[maybe work]:

change SQLiteDataReader.cs code on line 419,

add
 if (typ == DbType.Boolean) return affinity;
for
 case TypeAffinity.Text:

mistachkin added on 2019-12-08 18:20:18:
The proposed change would not be backward compatible.  A supported alternative is
to obtain the value as a string (e.g. via GetString) and attempt the conversion
to Boolean in the application code.