System.Data.SQLite

If a field of a column of type REAL, is filled with NaN, the method VerifyType(i, DbType.Double); called by GetDouble(int i) in SQLiteDataReader.cs throws an InvalidCastException.

   
CREATE TABLE dummy(
   id            integer PRIMARY KEY AUTOINCREMENT NOT NULL, 
   val           integer NOT NULL,
   val_critical  real  
);

SQLiteDataReader reader = command.ExecuteReader();
  while (reader.Read())
    Console.WriteLine(reader.GetDouble(2)); //throws an exception if it reads NaN

possible solution:
Add following line to SQLiteDataReader.cs at line:353 in method VerifyType(int i, DbType typ):
if (typ == DbType.Double) return affinity;

Also see ticket [e06c4caff3].

The type affinity for NaN is NULL, according to the SQLite core library.