Vidarls/Simple.Data.Mysql — Issue #3: [ Tip ] Null returns on Query
Author: daneb
Created: 2011-10-25 13:59:32+00:00
State: open

Kept running into "null" returns when executing a simple query, debugging into the Simple.Data method revealed the following error message:
Exception Details: MySql.Data.Types.MySqlConversionException:
Unable to convert MySQL date/time value to System.DateTime

This is not a bug per se, but here is the solution for others who may run into the problem:
Solution [ added in connection string ]
Allow Zero Datetime=true

PS. My version of mysql is: mysql-max-4.1.1.9