LINQ - Month in Words - Asked By Shan on 30-May-11 04:34 AM

Hi,

I am using the below query I getting the month as (1,2) I want to display as (jan,feb)

(from d in context.Table1

where d.ReceivedDate.Value.Year == (YearStart.Year)

group d by new

{

ReceivedDate = d.ReceivedDate.Value.Date.Month

} into g

select new

{

currentvalue = (System.Decimal?)g.Average(p => p.currentvalue),

g.Key.ReceivedDate

})

Jitendra Faye replied to Shan on 30-May-11 04:41 AM

Change your code like this-

(from d in context.Table1

where d.ReceivedDate.Value.Year == (YearStart.Year)

group d by new

{

ReceivedDate = d.ReceivedDate.Value.Date.ToString("MMM")
} into g

select new

{

currentvalue = (System.Decimal?)g.Average(p => p.currentvalue),

g.Key.ReceivedDate

})