Problem with Timestamp
Posted: Fri 14 Jan 2011 13:53
I have the following table in my MySQL database :
In my Visual Studio 2010-edmx the field Timestamp has the following atrributes:
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.
Any suggestions?
Best regards
Heiko Denk
Code: Select all
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
)
Code: Select all
StoreGeneratedPattern Computed
Type DateTime
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.
Any suggestions?
Best regards
Heiko Denk