public JsonResult GetOrdersPerPeriod(string filter) { var dbResult = db.SF_GetSalesPerPeriod().ToList().Where(x => x.anio == Int32.Parse(filter)); var orders = (from row in dbResult select new { row.full_date, row.q, row.cash }); return(Json(orders, JsonRequestBehavior.AllowGet)); }