下列查询怎么转换成LINQ，多谢
日期：2014-05-20 浏览次数：20684 次
下列查询如何转换成LINQ，谢谢
SELECT BH,GroupID , COUNT(*) AS Expr1
FROM CataLogDetail
where ((GroupID = 1) AND (Company =66))
AND ((LB = '身份') AND (LM IN ('合同工'))
OR (LB = '学历') AND (LM IN ('本科')) )
group by bh ,GroupID
having (count(*)=2)
------解决方案--------------------
SELECT BH,GroupID , COUNT(*) AS Expr1
FROM CataLogDetail
where ((GroupID = 1) AND (Company =66))
AND ((LB = '身份') AND (LM IN ('合同工'))
OR (LB = '学历') AND (LM IN ('本科')) )
group by bh ,GroupID
having (count(*)=2)
------解决方案--------------------
- C# code
var query=from c in db.CataLogDetail
where (c.GroupID==1 && c.Comany==66)
&&(c.LB=="身份" && new string[]{"合同工"}.Contains(c.LM))
|| (c.LB=="学历" && new string[]{"本科"}.Contains(c.LM))
group c by new {c.bh,c.GroupID} into g
where g.Count()==2
select new
{
g.Key.bh,
g.Key.GroupID,
Expr1=g.Count()
};
//代码手打，提供思路参考
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
