求此sql转成linq写法？？
0
悬赏园豆：10
[已解决问题]
解决于 2015-03-09 14:47
select t.opinion,t.node,t.result,d.flow_state,t.data_id, count(t.create_user)
from OMT_DEFECT_FLOW t inner join OMT_DEFECT_DETAIL d on d.id=t.data_id
group by d.flow_state,t.opinion,t.node,t.result,t.data_id having t.data_id='4c51493f-0751-4614-a462-35ed6ec169d0'
and d.flow_state='S030'
最佳答案
0
from t in OMT_DEFECT_FLOW join p in OMT_DEFECT_DETAIL on t.data_id =p.id group by ... ... select t
收获园豆：10
这样不行！
@renshen4322:
var q = from ct in Cd.Classifytb
join lt in Ld.Logtb
on ct.Id equals lt.Cid
group ct.Id by ct.Name1 into g
select new
{
g.Key,
cnt = g.Sum()
};
ViewData["classifylist"] = q.ToList();
其他回答(1)
0
............................定
你想表达什么？
