public HttpResponseMessage GetProducts() { var products = entities.proc_Get_AllProducts().ToList(); if (products.Count > 0) { return(Request.CreateResponse(HttpStatusCode.OK, products)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "No data found")); } }