using System.Collections.Generic;
public static void Main()
List<Log> logs = new List<Log>
new Log { LogID =1, LogDate = new DateTime(2014,09,23) },
new Log { LogID =2, LogDate = new DateTime(2014,10,10) },
new Log { LogID =3, LogDate = new DateTime(2014,09,23) },
new Log { LogID =4, LogDate = new DateTime(2014,09,23) },
new Log { LogID =5, LogDate = new DateTime(2014,10,10) },
new Log { LogID =6, LogDate = new DateTime(2014,09,23) },
new Log { LogID =7, LogDate = new DateTime(2014,09,23) },
new Log { LogID =8, LogDate = new DateTime(2014,10,10) },
new Log { LogID =9, LogDate = new DateTime(2014,09,23) },
new Log { LogID =10, LogDate = new DateTime(2014,10,20) }
var query = logs.Where(x => x.LogDate > new DateTime(2014, 09, 20) && x.LogDate < new DateTime(2014, 10, 12))
.GroupBy(x => x.LogDate).Select(x => new { LogDate = x.Key, Count = x.Count() });
foreach(var output in query)
Console.WriteLine("LogDate: {0}, Count : {1}",output.LogDate.ToShortDateString(),output.Count);
public int LogID { get; set; }
public DateTime LogDate { get; set; }