convert query to linq

Hi,
my advice is if you frequently using linq queries then,
use the below link and install sql to link converter,
even i use the same..
http://www.linqpad.net/[^]

it is so easy and you can just build any complex query in sql and then copy paste in linqpad then in a button click you will get a linq query.
even without having sound knowledge on Linq, i have completed a whole project which uses Linq :)


Good luck..

Hi dineshdena,

Don't forget

using System.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)
    };