在LINQ查询中具有和条件count() [英] having and conditional count() in linq query

问题描述

我要创建此查询:

select Something, count(Something) as "Num_Of_Times"
from tbl_results
group by Something
having count(Something)>5

我从这个开始:

tempResults.GroupBy(dataRow => dataRow.Field<string>("Something"))
   .Count() //(.......what comes here , to make Count()>5?)

推荐答案

from item in tbl_results
group item by item.Something into groupedItems
let count = groupedItems.Count()
where count > 5
select new { Something = groupedItems.Key, Num_Of_Times = count };

---

更新:这将为您提供IQueryable<DataRow>的结果:

---

UPDATE : This would give you the result as an IQueryable<DataRow> :

DataTable dt= new DataTable();
dt.Columns.Add("Something", typeof(int));
dt.Columns.Add("Num_Of_Times", typeof(int));

var results =   (from item in tbl_results
                 group item by item.Something into groupedItems
                 let count = groupedItems.Count()
                 where count > 2
                 select dt.Rows.Add(groupedItems.Key, count)).AsQueryable();

(请注意，它也填充了dt表)

(note that it also fills the dt table)

这篇关于在LINQ查询中具有和条件count()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！