Hi, we're doing some code-frist work in EF 6.1 targeting mySql, and we're hitting an issue where fields in classes use to hold timestamps (modification and creation times) are mapped to datetime fields in MySql, which truncates the values to the nearest second.
We'd like to get it down towards the millisecond, which I believe a timestamp data type would do.
Are there any tricks to coerce dotConnect to map this type to timestamps instead of datetimes?
EF6 Code-First MySql Forcing to Timestamp
Re: EF6 Code-First MySql Forcing to Timestamp
Well, damn my SQL Server centrism. Turns out that MySql prior to 5.6 always truncates fractional seconds for all data types, so our (impossible) solution is to upgrade to a newer version.
Yay...
Yay...