自动生成DTO(EF框架)
【0】安装相关工具包
PostgreSQL版本:
Npgsql.EntityFrameworkCore.PostgreSQL
Npgsql.EntityFrameworkCore.PostgreSQL.Design
Microsoft.EntityFrameworkCore.Tools
Microsoft.VisualStudio.Web.CodeGeneration.Design
Mysql 版本:
Install-Package MySql.Data.EntityFrameworkCore -Pre
Install-Package Pomelo.EntityFrameworkCore.MySql
Install-Package Microsoft.EntityFrameworkCore.Tools
Install-Package Microsoft.VisualStudio.Web.CodeGeneration.Design
Sql server 版本:
Install-Package Microsoft.EntityFrameworkCore
Install-Package Microsoft.EntityFrameworkCore.SqlServer
Install-Package Microsoft.EntityFrameworkCore.Tools
Install-Package Microsoft.VisualStudio.Web.CodeGeneration.Design
【1】VS Code中,终端-->新建终端-->进入.NET CORE项目API目录下-->执行下面的命令:
dotnet ef dbcontext scaffold "Host=xx.xxxxxxx.com;Database=dbName;Username=postgres;Password=密码" Npgsql.EntityFrameworkCore.PostgreSQL -f -o /home/xxxxx/PROJECT/NET\ CORE/projName.API/projName.Entities/Model/DTO/
【2】VisualStudio中,工具-->NuGet包管理器-->程序包管理控制台-->执行下面的命令:
dotnet ef dbcontext scaffold "Host=xx.xxxxxxx.com;Database=dbName;Username=postgres;Password=密码" Npgsql.EntityFrameworkCore.PostgreSQL -f -o /home/xxxxx/PROJECT/NET\ CORE/projName.API/projName.Entities/Model/DTO/
【3】在Ubuntu下的路径
dotnet ef dbcontext scaffold "Host=pg.aizhuhotel.com;Database=dbname;Username=postgres;Password=xxxxxx" Npgsql.EntityFrameworkCore.PostgreSQL -f -o /home/jenney/PROJECT/NET\ CORE/WxDingServer.API/WxDingServer.Entities/Model/DTO/
相关博文:
https://docs.microsoft.com/zh-cn/ef/core/get-started/aspnetcore/existing-db
https://www.cnblogs.com/ziye/p/7562889.html