public JsonResult GetOrders() { var dbResult = db.SF_GetOrdersFromCountryPerYear().ToList(); var orders = (from row in dbResult select new { row.ShipCountry, row.q_96, row.q_97, row.q_98, row.cash_96, row.cash_97, row.cash_98 }); return(Json(orders, JsonRequestBehavior.AllowGet)); }