How can I return an int value from a SQLite query?

c# sqlite windows-store-apps linqpad sqlite-net

from their documentation, you can use this code:

latCount = db.ExecuteScalar<int>(sql);

since it will return a row other than a list. I don't know why you are getting that error but your query will run on SQLFiddle.

CodeHunter