Cannot materialize TIMESTAMP field for MySQL database

I have a table created with the following script:

SET character_set_client = utf8;
CREATE TABLE `ruserslog` (
  `UL_ID` int(11) NOT NULL auto_increment,
  `UL_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `UL_OPCODE` int(11) NOT NULL default '0',
  `UL_RESCODE` int(11) NOT NULL default '0',
  `UL_KEY` text NOT NULL,
  `UL_SYSENCID` bigint(20) unsigned default NULL,
  `UL_NRLIC` char(14) default NULL,
  `UL_PAKIET` int(10) unsigned default NULL,
  `UL_USERIP` text,
  `UL_USERNAME` text,
  `UL_USERORG` text,
  `UL_USERADDR` text,
  PRIMARY KEY  (`UL_ID`),
  KEY `UL_SYSENCID` (`UL_SYSENCID`),
  KEY `UL_NRLIC` (`UL_NRLIC`)
) ENGINE=MyISAM AUTO_INCREMENT=1391781 DEFAULT CHARSET=utf8;

When I try to read entities from this table using Lightspeed, I get an error:

• "Unable to materialize field [Date] on type [<namespace here>.UsersLog]: field is type 'System.DateTime' but database returned type 'MySql.Data.Types.MySqlDateTime'. Check your table has an Id column and that your mappings are correct. See inner exception for details."

The inner exception is:

• "Specified cast is not valid."

In my model I have the field:

• Name: Date
• Column Name: UL_DATE
• Data Type: DateTime
• Is Nullable: False

I can workaround this problem by setting "Is Nullable" to True, but in this case all the dates in the Lightspeed objects are null. Maybe the problem is in parsing MySQL string - my locale is not English.

Please let me know how to fix this problem.

One more information:

I have added: "Allow Zero Datetime=true" to my ConnectionString and it didn't help. In fact none of the dates are empty in my DB.

The MySQL Connector maps the .NET DateTime type to the MySQL DATETIME type.  If you have the option to change the column data type to DATETIME, then that is the easiest solution.  If not, you will need to use a field converter to translate between the MySQL Connector's MySqlDateTime type and the .NET DateTime type.  There's a primer on this at http://www.mindscapehq.com/documentation/lightspeed/Working-with-Legacy-Databases/Mapping-Database-Types-to-Domain-Types and we'd be happy to provide additional guidance if required.

It works fine. Thank you :-)