我该如何将此转换为LINQ?
或者使用lambda表达式会很有帮助。
select i.CatName,COUNT(*) as n_items
from ixcxs i
group by i.CatName
或者使用lambda表达式会很有帮助。
var query = from i in ixcxs
group i by i.CatName into g
select new {
CatName = g.Key,
n_items = g.Count()
};
方法语法也相同:
var query = ixcxs.GroupBy(i => i.CatName)
.Select(g => new { CatName = g.Key, n_items = g.Count() });
尝试
ixcxs.GroupBy(g => g.CatName)
.Select(s => new
{
CatName = s.Key,
n_items = s.Count()
});
在查询语法中表示相同的意思:
from i in ixcxs
group i by i.CatName into g
select new
{
CatName = g.Key,
n_items = g.Count()
}
from t in db.ixcxs group t by new { t.CatName } into g select new { g.Key.CatName, Total = g.Count() };
但是,还有更优化的写法吗? - Urah