本文介绍了将查询转换为linq的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何将此查询转换为linq
选择年份(CreatedAt),从会员计算(会员ID)
其中ID = 1
按年份分组(CreatedAt)
How to convert this query to linq
select year(CreatedAt),count(MemberID) from Members
where ID = 1
group by year(CreatedAt)
推荐答案
using System.Linq;
否则你ca不要使用LINQ扩展方法,你需要创建存储数据的类。
这是代码:
otherwise you can't use neither LINQ extension method and you need to create the class to store the data.
Here is the Code:
[DataContract]
public class MemberModel
{
[DataMember]
public string year{ get; set; }
[DataMember]
public string Count{ get; set; }
}
var dataQuery =
from Mem in Members
where Mem.ID == 1
group Mem by new { Mem.year(CreatedAt) } into g
select new MemberModel()
{
year = g.Key.year(CreatedAt),
Count= g.Key.count(MemberID)
};
这篇关于将查询转换为linq的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!