.NET CORE EFCORE DBFIRST(SQLSERVER,MYSQL,ORACLE,POSTGRESQL)

SqlServ­er

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  -Force  -Schemas testdb

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 -Force  -Schemas seata

Ora­cle

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  -Force  -Schemas postgres

为您推荐

发表评论

您的电子邮箱地址不会被公开。