EF Core根据sql server或MySql数据库表生成实体类命令

前言：首先安装好EF Core和数据库对应包

sqlserver数据库安装ef迁移在上一篇文章

mysql数据库的在：

一 SQLServer数据库生成实体类命令

用到的NuGet包

Microsoft.EntityFrameworkCore
Microsoft.EntityFrameworkCore.Tools
Microsoft.EntityFrameworkCore.SqlServer
Microsoft.EntityFrameworkCore.Design

前面部分是数据库连接字符串，Microsoft.EntityFrameworkCore.SqlServer是数据库类型，-OutputDir D：Models/DataModels是保存到哪个文件夹

Scaffold-DbContext -Force “Data Source=LAPTOP-RMDBADPQ\NING;Initial Catalog=myDataBasetest; Persist Security Info=True; User ID=sa; Password=123456;” Microsoft.EntityFrameworkCore.SqlServer -OutputDir D：Models/DataModels

二 MySql数据库生成实体类命令

用到的NuGet包

Microsoft.EntityFrameworkCore
Microsoft.EntityFrameworkCore.Tools
Microsoft.EntityFrameworkCore.Design
Pomelo.EntityFrameworkCore.MySql

Scaffold-DbContext "server=.;userid=用户名;pwd=密码;port=3306;database=tech5_kj;sslmode=none;" Pomelo.EntityFrameworkCore.MySql -OutputDir D：Models/DataModels

三 Oracle数据库生成实体类命令

用到的NuGet包

Microsoft.EntityFrameworkCore
Microsoft.EntityFrameworkCore.Tools
Microsoft.EntityFrameworkCore.Design
Oracle.EntityFrameworkCore

caffold-DbContext -Connection "User Id=登录名;Password=密码;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.127.44)(PORT=1521))
                                                 (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));"Oracle.EntityFrameworkCore -Force -Project DBLib -OutputDir ExtModels -Tables tablename