MySQL Bugs: #102381: Could not find type mapping for column with data type 'datetime'

Bug #102381	Could not find type mapping for column with data type 'datetime'
Submitted:	26 Jan 2021 16:36	Modified:	28 Jan 2021 21:54
Reporter:	Gustavo Cuatepotzo	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S3 (Non-critical)
Version:	8.0.23	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
This is present in DBfirst aproach, when Scaffold-DbContext is executed we get below error message for those database fields declared as datetime

Could not find type mapping for column 'at_master.action_taken.RECORD_CREATED_ON' with data type 'datetime'. Skipping column.
Could not find type mapping for column 'at_master.action_taken.RECORD_UPDATED_ON' with data type 'datetime'. Skipping column.

How to repeat:

1.create a MySql database
2. create a table with some datetime column
3. create a console app with .net5 and add nuget packages: MySql.EntityFrameworkCore v5.0.0-m8.0.23 and Microsoft.EntityFrameworkCore.Tools
4. in Package ManagerConsole run command:
Scaffold-DbContext "{YourConnectionString}" MySql.EntityFrameworkCore -OutputDir {YourOutputPath} -f

result: datetime columns will be skipped

Suggested fix:
All the columns present in the database table should be created in EFCore

Posted by developer:
 
Fixed as of the upcoming MySQL Connector/NET 8.0.24 release, and here's the proposed changelog entry from the documentation team:

Several data types could not be mapped by running Scaffold-DbContext on
valid MySQL tables. This fix upgrades Microsoft Entity Framework libraries
to the latest and also adds all previously excluded mappings to the EFCore
and EFCore5 projects.

Thank you for the bug report.

Same issue with 
MySql.Data.EntityFrameworkCore 8.0.22

Bug #102680 marked as duplicate of this one

Hi
until now no relase: MySQL Connector/NET 8.0.24 release

Bug #102934 marked as duplicate of this one.

Hi.
Who can tell when there will be a new version of nuget for 3.1 and 5 EFCore?

https://insidemysql.com/mysql-connector-net-provider-for-entity-framework-core-renamed/

Just installed 8.0.24 on my computer and tried again to scaffold our database. Still getting the same yellow message:
Could not find type mapping for column 'database_name.table_name.column_name' with data type 'timestamp'. Skipping column.

Currently installed:
MySQL Server 8.0.24
MySQL for Visual Studio 8.0.24
MySQL Shell 8.0.24
Connector/ODBC 8.0.24
Connector/NET 8.0.24

Also have NuGet package:
MySql.Data 8.0.24
MySql.EntityFrameworkCore 5.0.3 (says 5.0.3+MySQL8.0.24 in the version)
Microsoft.EntityFrameworkCore 5.0.5
Microsoft.EntityFrameworkCore.Relation 5.0.5

Is there anything I'm missing?

Thank you!

Still happening in 8.0.25

I have the same Issue.

Ensure you are using MySql.EntityFrameworkCore instead MySql.Data.EntityFrameworkCore

Ensure you have the last version 5.05

This works for me.
Regards