Linq to Entities: apply date transformations

SqlFunctionsSample.cs

var chartData = from log in _contextProvider.Context.Logs
                            group log by new 
                            {
                              ApplicationName=log.Application.Name, 
                              Year= SqlFunctions.DatePart("Year", log.Timestamp), 
                              Month= SqlFunctions.DatePart("Month",log.Timestamp)
                            }
                            into logsPerApplication
                            select new 
                            {
                              Count = logsPerApplication.Count(), 
                              logsPerApplication.Key.ApplicationName, 
                              logsPerApplication.Key.Year,
                              logsPerApplication.Key.Month
                            };