linq 通过数组查询 在线等 （急）

[研发群187380948欢迎加入]

string[] numbers =this.HidCIdList.Value.Split(';');
var Query = (from p in adviceNoteEarnestMoneyTableEntities.View_AdviceNoteRightTable.Where(p => numbers.Contains(p.ProjectID.ToString()))

select new
{
RightsCmpCode = p.RightsCmpCode,
RightsCmpName = p.RightsCmpName,
ProjectCode = p.ProjectCode,
ProjectID = p.ProjectID,
ProjectMainNo = p.ProjectMainNo,
ProjectTitle = p.ProjectTitle,
RightsType = p.RightsType,
RightsTypeName = p.RightsTypeName,
}).OrderBy(p => p.ProjectID);

if (Query.Count() > 0)
{
this.RepList.DataSource = Query;
this.RepList.DataBind();
}
错误 是entity不支持tostring（）方法

[研发群187380948欢迎加入]

此问题已解决

[q107770540]

linq to ef 不支持，但是linq to object支持，所以： var Query = (from p in adviceNoteEarnestMoneyTableEntities.View_AdviceNoteRightTable.ToList().Where(p => numbers.Contains(p.ProjectID.ToString()))

[q107770540]

当然你也可以这样： string[] numbers =this.HidCIdList.Value.Split(';').Select(x=>int.Parse(x)); var Query = (from p in adviceNoteEarnestMoneyTableEntities.View_AdviceNoteRightTable.Where(p => numbers.Contains(p.ProjectID))

[xml111024]

看看最后生成的SQL，那个惨不忍睹啊。数组有几个元素，就几条语句，那还有性能，实在不能看

[研发群187380948欢迎加入]

引用 3 楼 q107770540 的回复:

当然你也可以这样： string[] numbers =this.HidCIdList.Value.Split(';').Select(x=>int.Parse(x)); var Query = (from p in adviceNoteEarnestMoneyTableEntities.View_AdviceNoteRightTable.Where(p => nu……

这个跟我的方法差不多，

引用 2 楼 q107770540 的回复:

linq to ef 不支持，但是linq to object支持，所以： var Query = (from p in adviceNoteEarnestMoneyTableEntities.View_AdviceNoteRightTable.ToList().Where(p => numbers.Contains(p.ProjectID.ToString())) ……

这个还是报错 提示不支持基元素什么的。算了该着你便宜结贴给你分吧