Bug #105896 Could not find type mapping for column with data type 'timestamp'
Submitted: 14 Dec 2021 21:42 Modified: 17 Sep 2022 10:36
Reporter: Diego Toro Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / NET Severity:S1 (Critical)
Version:8.0.27 OS:Any
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: EntityFrameworkCore, Scaffold-Dbcontext

[14 Dec 2021 21:42] Diego Toro 
Description:
Using Scaffold for generating entities I have a error "Could not find type mapping for column ... with data type 'timestamp'. Skipping column."

How to repeat:
Create table:
CREATE TABLE dummytable (
  id SMALLINT NOT NULL,
  modify TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id)
)

Use dotnet ef dbcontext scaffold command

Suggested fix:
Column with sql type TIMESTAMP must be mapped to C# DateTime
[24 Jan 2022 14:46] Diego Toro 
Hi team,

Any ETA ?
[25 Jan 2022 13:25] MySQL Verification Team 
Hello Diego Toro,

Thank you for the bug report.
Could you please try the workaround mentioned in the Bug #102381 and let us know if you are still facing the issue along with complete test case?

Regards,
Ashwini Patil
[26 Feb 2022 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[3 May 2022 14:25] Diego Toro 
Hi, the bug whith timestamp fields: 
Could not find type mapping for column .. with data type 'timestamp'. Skipping column, does not allow to update the connector and perform a successful scaffolding, it's blocking.

I try using Mysql.Data 8.0.29
and MySql.EntityFramework 5.0.5 and 6.0.1  but the error is the same.

Any ETA to fix this bug.
[17 Aug 2022 10:36] MySQL Verification Team 
Hello,

Thank you for the feedback.
Could you please provide repeatable test case (exact steps, sample project, etc. - please make it as private if you prefer) to confirm this issue at our end?
Also, please try the workaround mentioned in the Bug #102381. Thanks.

Regards,
Ashwini Patil
[18 Sep 2022 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".