前言:首先安装好EF Core和数据库对应包
sqlserver数据库安装ef迁移在上一篇文章 .net 6用EF Core基本创建表,迁移到SQL Server数据库
mysql数据库的在: .net 6用EF Core基本创建表,迁移到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