.NETCore 连接多种数据

pgsql接连

startup.cs
// 引用
Npgsql.EntityFrameworkCore.PostgreSQL
//添加依赖注入项
 AddDependencies(services);
 //添加数据库 pgsql
 services.AddDbContextPool<CourseDbContext>(options =>
   options.UseNpgsql(Configuration.GetConnectionString("Npgsql")));

appsetting.json
//pgsql
"ConnectionStrings": {
 "Npgsql": "Host=数据库地址;Port=5432 ;Database=数据库名;Username=用户名;Password=访问密码"
 },

mysql连接

//引用
MySql.Data.EntityFrameworkCore
//添加依赖注入项
 AddDependencies(services);
 //添加数据库 mysql
  services.AddDbContextPool<CourseDbContext>(options =>
     options.UseMySQL(Configuration.GetConnectionString("MySqlDBContext")));

"ConnectionStrings": {
    "MySqlDBContext": "Server=数据库地址;post=3306;database=数据名;user=用户名;password=密码"
  },

sqlserver连接

 //引用
  Microsoft.EntityFrameworkCore.SqlServer
  //添加依赖注入项
   AddDependencies(services);
    //添加数据库 sql server
    services.AddDbContextPool<CourseDbContext>(options =>              options.UseSqlServer(Configuration.GetConnectionString("SqlDBContext")));

"ConnectionStrings": {
    "SqlDBContext": "Server=数据库地址;Database=数据名;uid=用户名;pwd=密码"
  },

 

转载于:https://my.oschina.net/u/3872144/blog/1836210