NHibernate multi-threading issue (多线程问题)
int limitTimes; int .TryParse(ConfigurationManager.AppSettings[ "LimitTimes" ], out limitTimes); var redoPurchaseEntityList = this .redoPurchaseEntityRepository.FindByExpression(p => p.SendNumber < limitTimes).ToList(); if (redoPurchaseEntityList.Count == 0) { return ; } Parallel.ForEach( this .redoPurchaseProvideList, redoPurchase => { var task = new Task(() => redoPurchase.RedoPurchase(redoPurchaseEntityList)); task.StartAndContinueWith(); }); |
上面代码主要是从数据库中查询出一个表的list集合然后多线程并行查找同一个list,会得到一个错误信息
There is already an open DataReader associated with this Command which must be closed first.
at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command)
因为用的是一个session,导致读取错误多线程不可互用同一个session.
可参考 http://stackoverflow.com/questions/7886260/nhibernate-multi-threading-issue
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步