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;
}
....
当我迭代子集时,我会得到错误:"查询结果不能枚举多次"。请告知。非常感谢。
好的,得到了。我只需要实现我的ObjectResult,就可以再次查询它:var rawSurveys=_db.sp_GetCustSurveys().toList()它似乎起作用了。