Problem with Timestamp using .Net entity framework and Devart dotConnect for MySQL

I have the following table in my MySQL database :

CREATE TABLE IF NOT EXISTS Benutzer (

Id INTEGER PRIMARY KEY AUTO_INCREMENT,

Login VARCHAR(20) NOT NULL,

Nachname VARCHAR(50) NOT NULL,

Vorname VARCHAR(50) NOT NULL,

Timestamp TIMESTAMP DEFAULT 0 ON UPDATE CURRENT_TIMESTAMP

)

In my Visual Studio 2010-edmx the field Timestamp has the following atrributes:

StoreGeneratedPattern: Computed

Type: DateTime

On inserting a new record into the table I get the following exception:

Devart.Data.MySql.MySqlException: Incorrect datetime value: '0001-01-01 00:00:00' for column 'Timestamp' at row 1.

I need the Timestamp-field to handle concurrency issues.

Version of Devart.Data.MySql.Entity开发者_运维问答 is 6.0.86.0. Im am using Visual Studio 2010 and .Net Runtime 3.5 Sp1.

Help is appreciated.

---

Maybe you should IGNORE update this DateTime field by EntityFramework. Just let database handle its value update automatically.

It seems EntityFramework give a default value to DateTime field which is "0001-01-01 00:00:00", it's the default behavior of .NET.

    [DatabaseGenerated(DatabaseGeneratedOption.Computed)]
    public DateTimeOffset CreateDate { get; set; }

Use above annotation will tell EF to ignore the CreateDate when make changes to the entity.