score:1

Accepted answer
datetime fromdate = new datetime(2011, 1, 1);
datetime todate = new datetime(2011, 1, 1);

var query = from p in db.payments
            where p.type == 1 && p.position == 1 && 
            p.date >= fromdate && p.date <= todate
            group p by p.applicationno into g
            select new {
                 applicationno = g.key,
                 cnt = g.count(),
                 amnt = g.sum(x => x.amount)
           };

Related Query

More Query from same tag