System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 0dd830c939988f64e477d47d8a2dc03e0351ae73
Title: Reading NULL from string column should return null (not throw exception)
Status: Closed Type: Feature_Request
Severity: Important Priority: Medium
Subsystem: Data_Reader Resolution: Not_Backwards_Compatible
Last Modified: 2015-07-28 02:02:19
Version Found In: 1.0.97.0
User Comments:
anonymous added on 2015-07-28 01:22:57:
Writing null to a string column writes NULL. However when reading from a string column with SqliteReader.ReadString, reading a NULL results in a InvalidCastException. This should return null and not throw an exception.

mistachkin added on 2015-07-28 02:02:19: (text/x-fossil-plain)
Unfortunately, this behavior cannot be changed as it would break a lot of existing
applications.

The IsDBNull() method can be used to check for NULL prior to calling GetString().