LINQ - Week of a month - Asked By Shan on 23-May-11 03:25 AM

Hi,

I want to convert the below query to LINQ

SELECT avg(currentvalue) AS Average, datediff(week, convert(varchar(6), ReceivedDate, 112) + '01', ReceivedDate) + 1 AS Week

FROM TableName

WHERE (id = 19) AND (CONVERT(datetime, ReceivedDate, 103) >= '01/04/2026') AND (CONVERT(datetime, ReceivedDate, 103) <= '04/30/2011')

GROUP BY datediff(week, convert(varchar(6), ReceivedDate, 112) + '01', ReceivedDate) + 1 order by 2

Anoop S replied to Shan on 23-May-11 03:57 AM

Use this code

public static List<DateTime> GetDates(int year, int month)

{

return Enumerable.Range(1, DateTime.DaysInMonth(year, month))

.Select(day => new DateTime(year, month, day))

.Where(dt => dt.DayOfWeek != DayOfWeek.Sunday &&

dt.DayOfWeek != DayOfWeek.Saturday)

.ToList();

}