Netcore +ef+mysql generating entity classes from a database to a project

1. Click "Tools", "NuGet Package Manager", "Package Manager Console"

Install the following packages separately

Mysql version:

Install-package MySql.Data.EntityFrameworkCore-Preinstall-Package Pomelo.EntityFrameworkCore.MySqlInstall-PackageMicrosoft.EntityFrameworkCore.ToolsInstall- Package Microsoft.VisualStudio.Web.CodeGeneration.Design

SQL Server version:

install-PackageMicrosoft.entityframeworkcoreinstall-Package Microsoft.EntityFrameworkCore.SqlServerInstall-PackageMicrosoft.EntityFrameworkCore.ToolsInstall -package Microsoft.VisualStudio.Web.CodeGeneration.Design

2. Generate the entity class in the Package Manager console by executing the following statement
--mysql version:

" server=.; Userid=tech5_kj;pwd=xxx;port=3306;database=tech5_kj;sslmode=none; " Pomelo.entityframeworkcore.mysql-outputdir Models-Forceor scaffold"server=.; Userid=tech5_kj;pwd=xxx;port=3306;database=tech5_kj;sslmode=none; " Pomelo.entityframeworkcore.mysql-outputdir Models-usedatabasenames-force

--sql Server version

" Data Source=.;i Nitial Catalog=efcore_dbfirst; User Id=sa; password=sa.123" microsoft.entityframeworkcore.sqlserver-outputdir Models-force

Parameter description:

-OUTPUTDIR * * * * * * * * * * * * * * * * *  * * * * * * * * file directory -contextdir dbcontext files directory-context Schemas * * * The schema of the data table where the entity data needs to be generated -tables * * * a collection of data tables that need to generate Entity Data -dataannotations-  Usedatabasenames directly using the table and column names in the database (some versions are not supported)-force enforcement, overriding existing entity files

Netcore +ef+mysql generating entity classes from a database to a project