/// <summary> /// 配置连接字符串 /// </summary> /// <param name="optionsBuilder"></param> protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { switch (TDB) { case TypeDB.MySQL: optionsBuilder.UseMySql(GlobalVar.GetValue("ConnectionStrings:MySQLConn")); break; case TypeDB.SQLite: optionsBuilder.UseSqlite(GlobalVar.GetValue("ConnectionStrings:SQLiteConn")); break; case TypeDB.SQLServer: optionsBuilder.UseSqlServer(GlobalVar.GetValue("ConnectionStrings:SQLServerConn"), options => { //启用 row_number 分页 (兼容2005、2008) //options.UseRowNumberForPaging(); }); break; case TypeDB.PostgreSQL: optionsBuilder.UseNpgsql(GlobalVar.GetValue("ConnectionStrings:PostgreSQL")); break; } //注册日志(修改日志等级为Information,可查看执行的SQL语句) optionsBuilder.UseLoggerFactory(MyLoggerFactory); }