Donet Core中EFCore的DbFirst生成資料庫實體

使用EFCore用指令生成實體

1.安裝Nuget包Microsoft.EntityFrameworkCore.Tools,

注意:如果是MySQL需要安裝Pomelo.EntityFrameworkCore.MySql

然後執行指令:

Mysql:

Scaffold-DbContext “server=;user id=;password=;port=;database=;Charset=utf8;SslMode=None” “Pomelo.EntityFrameworkCore.MySql” -OutputDir Models

SqlServer

Scaffold-DbContext “server=;user id=;password=;database=;” “Microsoft.EntityFrameworkCore.SqlServer” -OutputDir Models

需要單表則:

Scaffold-DbContext “server=;user id=;password=;database=;” “Microsoft.EntityFrameworkCore.SqlServer” -tables “” -OutputDir Models

Mysql應該還有其他方式生成，以後測試再補充

2018/1/29

通過測試:Mysql不需要再安裝Pomelo.EntityFrameworkCore.MySql

隻需要安裝 MySql.Data.EntityFrameworkCore即可

Scaffold-DbContext “server=;user id=;password=;database=;” “MySql.Data.EntityFrameworkCore” -OutputDir Models