how to get the sum count based on the month of a date in linq

Question

0.00/5 (No votes)

See more:

hi all,
i do have a requirement that to get the sum result based on the no of records per month.
i have written the code as following.

C#

var Interviews = spe.Interviews
                .Where(w => w.InterviewDate.Year == year)
                .Join(spe.Recruiters, i => i.Recruiter, r => r.RecruiterId, (i, r) => new
                {
                    r.RecruiterId,
                    i.InterviewDate
                }).GroupBy(gp => new { RecruiterId = gp.RecruiterId, InterviewDate = gp.InterviewDate })
                .Select(x => new { RecruiterId = x.Key.RecruiterId, InterviewDate = x.Key.InterviewDate, InterviewCount = x.Count() }).ToList();

Note:- In the above code i am getting the count i.e interview count by date , but the count which i want is per month, please help me to achieve this!!!

Posted 1-Dec-14 17:24pm

pavan_ kumar

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Accepted Answer · 2014-12-01T17:30:00

C#

var Interviews = spe.Interviews
                .Where(w => w.InterviewDate.Year == year)
                .Join(spe.Recruiters, i => i.Recruiter, r => r.RecruiterId, (i, r) => new
                {
                    r.RecruiterId,
                    i.InterviewDate
                }).GroupBy(gp => new { RecruiterId = gp.RecruiterId, Month= gp.InterviewDate.Month })
                .Select(x => new { RecruiterId = x.Key.RecruiterId, InterviewMonth = x.Key.Month, InterviewCount = x.Count() }).ToList();

if you need to get month as string replace

C#

Month= gp.InterviewDate.Month

with

C#

Month= gp.InterviewDate.ToString("MMM")

how to get the sum count based on the month of a date in linq

1 solution

Solution 1

Add your solution here

Preview 0

how to get the sum count based on the month of a date in linq

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us