I want to read int from sqLite.
But it returns long on integer values.
Should I just make conversion to short int
int var = 0;
var = (int) dr["variable"];
Or there is another way?
That looks like a datareader ... so use dr.GetInt32(index) instead. Calling the various GetXXX() functions on the DataReader is faster than using the [] array indexer too.
Robert