public HttpResponseMessage Get() { if (entities.sp_getCropData().ToList().Count == 0) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No Data Found")); } return(Request.CreateResponse <IEnumerable <sp_getCropData1_Result> >(HttpStatusCode.OK, entities.sp_getCropData1().ToList())); }