本文介绍了将查询转换为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的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-05 12:18
查看更多