Subset of System.Data.Objects.ObjectResult

本文关键字:Objects ObjectResult Data System of Subset | 更新日期: 2023-09-27 18:20:50

我正在获取执行存储过程sp_GetCustSurveys的System.Data.Objects.ObjectResult,然后迭代结果集。在主循环中,我想创建一个子集项目(具有相同id的项目列表):

using (MyObject_Surveys _db = new MyObject_Surveys ())
        {
            _db.CommandTimeout = 10000;
            var rawSurveys = _db.sp_GetCustSurveys();
            foreach (var survey in rawSurveys)
            {
               var surveyMultipleLangs = rawSurveys.Where(w => w.Id.Contains("123"));
                        foreach (var itm in surveyMultipleLangs)
                        {
                            var myName = itm.Name;
                            var myLanguage = itm.Language;
                        } 
               ....

当我迭代子集时,我会得到错误:"查询结果不能枚举多次"。请告知。非常感谢。

Subset of System.Data.Objects.ObjectResult

好的,得到了。我只需要实现我的ObjectResult,就可以再次查询它:var rawSurveys=_db.sp_GetCustSurveys().toList()它似乎起作用了。