/// <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);
}
