• .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
  • 相关阅读:
    MySQL数据库备份与还原
    MySQL的增、删、改、查
    MySQL与安全
    网址收集
    实现批量添加10个用户,用户名为user01-10,密码为user后面跟3个随机字符
    运维笔试Python编程题
    javascript 正则表达式 详细入门教程
    Web UI回归测试 -- BackstopJS 入门
    js 链接传入中文参数乱码解决
    项目搭建注意事项
  • 原文地址:https://www.cnblogs.com/jianghaidong/p/15184472.html
Copyright © 2020-2023  润新知