.net core efcore dbfirst(sqlserver,mysql,oracle,postgresql)

https://docs.microsoft.com/zh-cn/ef/core/dbcontext-configuration/

SqlServer

Install-Package Microsoft.EntityFrameworkCore.SqlServer
Install-Package Microsoft.EntityFrameworkCore.Design
Install-Package Microsoft.EntityFrameworkCore.Tools

 

Scaffold-DbContext "server=.;database=testdb;uid=sa;pwd=123456;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir SqlServerModels

Mysql

Install-Package Pomelo.EntityFrameworkCore.MySql
Install-Package Microsoft.EntityFrameworkCore.Design
Install-Package Microsoft.EntityFrameworkCore.Tools

 

Scaffold-DbContext "server=127.0.0.1;port=3306;database=seata;uid=root;pwd=mysql123;" Pomelo.EntityFrameworkCore.MySql -OutputDir MysqlModels

Oracle

Install-Package Oracle.EntityFrameworkCore
Install-Package Microsoft.EntityFrameworkCore.Design
Install-Package Microsoft.EntityFrameworkCore.Tools

 

Scaffold-DbContext "Data Source=127.0.0.1:1521/test;User ID=root;Password=123456;" Oracle.EntityFrameworkCore -OutputDir OracleModels

 postgreSQL

Install-Package Npgsql.EntityFrameworkCore.PostgreSQL
Install-Package Microsoft.EntityFrameworkCore.Design
Install-Package Microsoft.EntityFrameworkCore.Tools

 

Scaffold-DbContext "Server=localhost;Port=5432;Database=postgres;User Id=postgres;Password=123456" Npgsql.EntityFrameworkCore.PostgreSQL -OutputDir PostgreSQLModels