public ActionResult Graph() { var context = new NewsdbEntities(); ArrayList xValue = new ArrayList(); ArrayList yValue = new ArrayList(); // var temp = (from m in db.Journalists where (m.Journalist_Id == temper) && (m.Id_System == userid) && (m.Id_System != null) select m.Journalist_Id).FirstOrDefault(); // var count = db.Suspenses.GroupBy(s => s.SuspenseDate.Month).Select(g => g.Count()); KeyValuePair <string, int> list = new KeyValuePair <string, int>(); var result = context.Articles.GroupBy(m => m.articleDate.Value.Year).Select(x => new { Date_Published = x.Key, Count = x.Count() }).ToList(); // var results = (from c in context.Articles.GroupBy(m => m.Date_Published.Year) select c.Count()); result.ToList().ForEach(rs => xValue.Add(rs.Date_Published)); result.ToList().ForEach(rs => yValue.Add(rs.Count)); new Chart(width: 600, height: 400, theme: ChartTheme.Green) .AddTitle("Yearly Increase in Articles") .AddSeries("Default", chartType: "Column", xValue: xValue, yValues: yValue) .Write("bmp"); return(null); }