System.Data.SQLite

Hi, i have this line of code: int? tmp = dr[0] as int?; that assign a db field to a nullable integer variable. But with every integer fields i get always a null value. If i add this line of code after the first one object obj = dr[0]; all works fine and the obj's value is correct. What am i wrong ?? I'm using System.Data.SQLite.DLL Ver 1.0.66 Thanks in advance Stefano

SQLite returns integer fields as longs most of the time, AFAICT.  Try something like this (assuming dr is a SQLiteDataReader):

long? tmp = dr.IsDBNull(0) ? (long?)null : dr.GetInt64(0);

or ...

int? tmp = dr.IsDBNull(0) ? (int?)null : (int)dr.GetInt64(0);