Sum and Grouping in Linq : Hi Bill,Try:varquery=mgr.DuesOweds ...

Wed, 08 Jan 2014 16:28:17 -700

Author: sbelini
Subject: 4632
Posted: 08-Jan-2014 at 4:28pm

Hi Bill,

Try:

      var query = mgr.DuesOweds        .Where(d => d.SocSecNo == member.SocSecNo && d.DuesCatCd.StartsWith("D"))
        .GroupBy(d => d.DuesYearMonth)
        .Select(d => new { duesYearMonth = d.Key, duesRate = d.Sum(d1 => d1.DuesAmount) })        .Where(d => d.duesRate != 0)        .OrderByDescending(d => d.duesYearMonth);

Sum and Grouping in Linq : How would i do the following in...

Sun, 29 Dec 2013 10:26:59 -700

Author: BillG
Subject: 4632
Posted: 29-Dec-2013 at 10:26am

How would i do the following in Linq. Here is the SQL

Select duesyearmontn, sum(duesamount) as duesrate
from duesowed
where socsecno = "999-99-9999' and duescatcd = 'D'
group by duesyearmonth
having sum(duesamount) <> 0
order by duesyearmonth desc

this is what i have so far

               var duesOwedQuery = _manager.DuesOweds                    .Where(d => d.SocSecNo == member.SocSecNo && d.DuesCatCd.StartsWith("D"))                    .OrderByDescending(d => d.DuesYearMonth);                 var duesOweds1 = duesOwedQuery.Execute<DuesOwed>();
how do i handle the group by and having clause?

Bill

DevForce Community Forum : Sum and Grouping in Linq

Sum and Grouping in Linq : Hi Bill,Try:varquery=mgr.DuesOweds ...

Sum and Grouping in Linq : How would i do the following in...