NET Core 3.1升级到NET5，数据库是Oracle，报错“Connection open error ” 返回
上善若水 发布于2020/12/1
原始代码如下：
string strSql = "select menuName,MenuId,ParentId,Url from SysMenu where MenuId in(select d.MenuId from SysUserRole c inner join SysRoleMenu d on c.RoleId=d.RoleId where c.EmpId='1')";
var db = GetInstance(1);
IEnumerable<SysMenuViewModel> dataLists = await db.SqlQueryable<SysMenuViewModel>(strSql).ToListAsync();
在net core 3.1可以正常执行，到了net 5报错如下
SqlSugar.SqlSugarException: English Message : Connection open error . Exception has been thrown by the target of an invocation.
Chinese Message : 连接数æ®åº“过程ä¸å‘生错误，检查æœåŠ¡å™¨æ˜¯å¦æ£å¸¸è¿žæŽ¥å—符串是å¦æ£ç¡®ï¼Œå®žåœ¨æ‰¾ä¸åˆ°åŽŸå› 请先Google错误信æ¯ï¼šException has been thrown by the target of an invocation..
at SqlSugar.AdoProvider.GetDataReaderAsync(String sql, SugarParameter[] parameters)
at SqlSugar.QueryableProvider`1.GetDataAsync[TResult](KeyValuePair`2 sqlObj)
at SqlSugar.QueryableProvider`1._ToListAsync[TResult]()
热忱回答（4）
-
上善若水 VIP0
2020/12/1
刚搜了下，已经有了Issue，详细见https://github.com/dotnet/aspnetcore/issues/27872，是oracle暂时没出支持net5，先降级到 net core3.1，继续等了
0 回复 -
fate stay night VIP0
2020/12/10 回复 -
fate stay night VIP0
2020/12/1
按上面操作
0 回复 -
上善若水 VIP0
2020/12/5
@fate stay night：感谢凯哥
0 回复