public JsonResult GetOrders() { var dbResult = db.SF_GetOrdersDetails(); var orders = (from row in dbResult select new { row.CategoryID, row.CategoryName, row.Discount, row.Employee, row.OrderDate, row.OrderID, row.ProductID, row.ProductName, row.Quantity, row.ShipCity, row.ShipCountry, row.ShippedDate, row.ShipPostalCode, row.Total, row.UnitPrice }); return(Json(orders, JsonRequestBehavior.AllowGet)); }