NuGet:管理控制台
輸入:
sqlserver
EntityFramework,Microsoft.EntityFrameworkCore.Tools
PM > Scaffold-DbContext "Data Source=127.0.0.1;Initial Catalog=Test1;User ID=sa;Password=123456;MultipleActiveResultSets=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models
mysql
安裝 MySql.Data.EntityFrameworkCore,Microsoft.EntityFrameworkCore.Tools
Scaffold-DbContext "server=127.0.0.1;port=3306;user=root;password=123;database=jstest" MySql.Data.EntityFrameworkCore -OutputDir Entitys
//指令格式為:
//Scaffold-DbContext "資料庫連接配接字元串" EF元件名(Microsoft.EntityFrameworkCore.SqlServer/Pomelo.EntityFrameworkCore.MySql/等等) -OutputDir 輸出檔案夾名稱
net core 3.0 mysql
Install-Package Pomelo.EntityFrameworkCore.MySql -Version 3.0.0
Scaffold-DbContext "server=127.0.0.1;port=3306;user=root;password=test;database=test" Pomelo.EntityFrameworkCore.MySql -OutputDir Entitys
微軟官方連接配接:
微軟官方連接配接