LINQ. Grouping by days. How to do this easily?

Question

I can't seem to find any god reference on this. I have alot of data in SQL with dates. So I wanted to make a line chart to show this data over time. If I want to show it over a perioud of days then I need to group by days.. But the LOGDATE is the full date.. not the DAY..

So I have this below.. but LINQ doesnt know what 'DayOfYear' property is.. HELP

 var q = from x in dc.ApplicationLogs
                let dt = x.LogDate
                group x by new { dayofyear = dt.Value.DayOfYear } into g
                select new
                {
                    iCount = g.Count(),
                    strDate = g.Key
                };

Answer 1

Why are you using:

    let dt = x.LogDate
    group x by new { dayofyear = dt.Value.DayOfYear } into g

instead of just:

    group x by x.LogDate.Value.DayOfYear into g

I'm not sure about this, but it's possible using an anonymous object like that in your group by clause is messing up L2S.

Answer 2

You want .Date to get the date part of a DateTime not DayOfyear unless you are deliberately trying to put the same day of the year from each year into the group.