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