mysql bit转bool失败,带有Mysql的EF Core无法将BIT（1）设置为布尔值

I am trying to generate DB classes from the existing database (DB first) through. Net core CLI.

The DB was perfectly working with EF5 and .net4.5 but after migrate to EF core the bit(1) field is not scaffolding as bool instead it is generating as short.

Also tried with TinyInt(1) but no luck.

Technology Stack -

.Net core - 2.2

MySql.Data.EntityFrameworkCore (8.0.15)

MySQl Connector Net 8.0.13

innodb_version 8.0.13

解决方案

First you need to add this packages from Nuget:

MySql.Data.EntityFrameworkCore

Microsoft.EntityFrameworkCore.Design

then run this command :

Scaffold-DbContext "server=localhost;port=3306;user=root;password=mypass;database=sakila" MySql.Data.EntityFrameworkCore -OutputDir model -f