I have a POCO(myPoco) with a datetime field and a table in a mysql database with a time field. The mapping between myPoco and the database table worked fine until I upgraded from 4.0.39 (I think), to 4.0.40. Now I get a System.FormatException when I do a db.Select< myPoco>().
I read something about poor support of the database TIME field in ormlite. Should I stop using time in the database and change that to bigint. And then change myPoco dateTime field to timespan? As I understand ormlite will then store my timespan as ticks in the database.