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: Assigned Account 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".

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.058 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.