EFCore项目中不同数据库需要安装的包

• Oracle

  Install-Package Microsoft.EntityFrameworkCore
  Install-Package Oracle.EntityFrameworkCore
  Install-Package Microsoft.EntityFrameworkCore.Tools
  Install-Package Microsoft.VisualStudio.Web.CodeGeneration.Design
  

  • 连接字符串：

    "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));User Id=登录名;Password=密码;"

• SqlServer

  Install-Package Microsoft.EntityFrameworkCore
  Install-Package Microsoft.EntityFrameworkCore.SqlServer
  Install-Package Microsoft.EntityFrameworkCore.Tools
  Install-Package Microsoft.VisualStudio.Web.CodeGeneration.Design
  

  • 连接字符串

    "Data Source=192.168.12.34;Initial Catalog=数据库名称;User ID=登录名;Password=密码"

• MySQL

  Install-Package MySql.Data.EntityFrameworkCore -Pre
  Install-Package Pomelo.EntityFrameworkCore.MySql
  Install-Package Microsoft.EntityFrameworkCore.Tools
  Install-Package Microsoft.VisualStudio.Web.CodeGeneration.Design
  

  • 连接字符串

    "server=.;userid=root;pwd=xxx;port=3306;database=dbtest;sslmode=none;"