如何将SQL(计数,顺序)转换为LINQ(计数,顺序)? [英] How to convert SQL (count, order by) to LINQ (count, order by)?
本文介绍了如何将SQL(计数,顺序)转换为LINQ(计数,顺序)?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个查询和它的工作在SQL,但我使用LINQ,我不知道如何转换它。任何人都可以帮助我?
这是我的查询:
select o.name,count(o.officeID)
来自SysTransaction t
left join SysOffice o on t.officeID = o.officeID
group by o.officeID
解决方案试试
从t中的sysTransaction
加入o在sysOffice中的t.OfficeId等于o.OfficeId加入
从一个加入的
组一个一个.OfficeId到分组
select new
{
officeId = grouped.Key,
count = grouped.Count()
};
I have a query here and its working in SQL, but I am using LINQ and I don't know how to convert it. Can anyone help me?
This is my query:
select o.name, count(o.officeID) from SysTransaction t left join SysOffice o on t.officeID = o.officeID group by o.officeID
解决方案try this
from t in sysTransaction join o in sysOffice on t.OfficeId equals o.OfficeId into joined from one in joined group one by one.OfficeId into grouped select new { officeId = grouped.Key, count = grouped.Count() };
这篇关于如何将SQL(计数,顺序)转换为LINQ(计数,顺序)?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文