数据库连接串

db.provider.Development.json

{
  //业务个性化库
  "ConnBsCode": {
    "name": "ConnBs",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "remark": "",
    "read": [
      "Data Source=localhost;Initial Catalog=rg_bs_code;User Id=root;Password=rg123456!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog=rg_bs_code;User Id=root;Password=rg123456!;charset=utf8"
    ]
  },
  //权限核心库
  "ConnBo": {
    "name": "ConnBo",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "remark": "",
    "read": [
      "Data Source=localhost;Initial Catalog=bt_auth_bo;User Id=root;Password=rg123456!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog=bt_auth_bo;User Id=root;Password=rg123456!;charset=utf8"
    ]
  },
  //平台集成业务存储库
  "ConnBs": {
    "name": "ConnBs",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "remark": "",
    "read": [
      "Data Source=localhost;Initial Catalog=rg_auth_bs;User Id=root;Password=rg123456!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog=rg_auth_bs;User Id=root;Password=rg123456!;charset=utf8"
    ]
  },
  //项目管理系统 rg_bs_pm
  "ConnPM": {
    "name": "ConnPM",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "read": [
      "Data Source=localhost;Initial Catalog=rg_bs_pm;User Id=root;Password=rg123456!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog=rg_bs_pm;User Id=root;Password=rg123456!;charset=utf8"
    ]
  },
  //客户关系管理系统 rg_bs_crm
  "ConnCrm": {
    "name": "ConnCrm",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "read": [
      "Data Source=localhost;Initial Catalog=rg_bs_crm;User Id=root;Password=rg123456!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog=rg_bs_crm;User Id=root;Password=rg123456!;charset=utf8"
    ]
  },
  //简单论坛 rg_bs_bbs
  "ConnBbs": {
    "name": "ConnBbs",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "read": [
      "Data Source=localhost;Initial Catalog=rg_bs_bbs;User Id=root;Password=rg123456!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog=rg_bs_bbs;User Id=root;Password=rg123456!;charset=utf8"
    ]
  },
  //消息通知
  "ConnMsg": {
    "name": "ConnMsg",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "read": [
      "Data Source=localhost;Initial Catalog=bt_msg_bs;User Id=root;Password=rg123456!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog=bt_msg_bs;User Id=root;Password=rg123456!;charset=utf8"
    ]
  },
  //操作记录日志库
  "ConnLog": {
    "name": "ConnLog",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "remark": "",
    "read": [
      "Data Source=localhost;Initial Catalog=rg_auth_log;User Id=root;Password=rg123456!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog=rg_auth_log;User Id=root;Password=rg123456!;charset=utf8"
    ]
  },
  //操作添加、修改、删除日志
  "ConnOpLog": {
    "name": "ConnOpLog",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "remark": "",
    "read": [
      "Data Source=localhost;Initial Catalog=rg_auth_log_op;User Id=root;Password=rg123456!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog=rg_auth_log_op;User Id=root;Password=rg123456!;charset=utf8"
    ]
  },
  //系统日志 登录
  "ConnSysLog": {
    "name": "ConnSysLog",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "remark": "",
    "read": [
      "Data Source=localhost;Initial Catalog=rg_auth_log_sys;User Id=root;Password=rg123456!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog=rg_auth_log_sys;User Id=root;Password=rg123456!;charset=utf8"
    ]
  },
  //异常等日志信息
  "ConnTrackLog": {
    "name": "ConnTrackLog",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "remark": "",
    "read": [
      "Data Source=localhost;Initial Catalog=rg_auth_log_track;User Id=root;Password=rg123456!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog=rg_auth_log_track;User Id=root;Password=rg123456!;charset=utf8"
    ]
  },
  //用户行为日志
  "ConnUserBehavior": {
    "name": "ConnTrackLog",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "remark": "",
    "read": [
      "Data Source=localhost;Initial Catalog=rg_auth_log_ub;User Id=root;Password=rg123456!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog=rg_auth_log_ub;User Id=root;Password=rg123456!;charset=utf8"
    ]
  },
  //商城库
  "ConnMall": {
    "name": "ConnMall",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "remark": "",
    "read": [
      "Data Source=localhost;Initial Catalog=rg_bs_mall;User Id=root;Password=rg123456!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog=rg_bs_mall;User Id=root;Password=rg123456!;charset=utf8"
    ]
  },
  //存储bridger 文件 临时缓存数据
  "ConnCacheBridge": {
    "databaseType": "Sqlite",
    "name": "ConnCacheBridge",
    "providerName": "Microsoft.Data.Sqlite",
    "read": [
      "Data Source=~/App_Data/DB/rg/rg_sub_push_bridge.db"
    ],
    "write": [
      "Data Source=~/App_Data/DB/rg/rg_sub_push_bridge.db"
    ]
  },
  //存储mapper 文件 临时缓存数据
  "ConnCacheMapper": {
    "databaseType": "Sqlite",
    "name": "ConnCacheMapper",
    "providerName": "Microsoft.Data.Sqlite",
    "read": [
      "Data Source=~/App_Data/DB/rg/rg_sub_push_mapper.db"
    ],
    "write": [
      "Data Source=~/App_Data/DB/rg/rg_sub_push_mapper.db"
    ]
  },
  //分库分表 库、表、列、值 映射数据
  "ConnShred": {
    "databaseType": "Sqlite",
    "name": "ConnShred",
    "providerName": "Microsoft.Data.Sqlite",
    "read": [
      "Data Source=~/App_Data/DB/rg/rg_bo_shred.db"
    ],
    "write": [
      "Data Source=~/App_Data/DB/rg/rg_bo_shred.db"
    ]
  },
  //存储websoket时间戳信息
  "ConnWs": {
    "databaseType": "Sqlite",
    "name": "ConnWs",
    "providerName": "Microsoft.Data.Sqlite",
    "read": [
      "Data Source=~/App_Data/DB/bt/bt_bo_ws.db"
    ],
    "write": [
      "Data Source=~/App_Data/DB/bt/bt_bo_ws.db"
    ]
  }
}

bo_ws.xml websoket 数据更新时间说明

SqlLite必须以 Data Source=~ 开始