DateTime? yesterday = DateTime.Today.AddBusinessDays(-4); var data = from c in db.data_qy where c.UploadDate == yesterday && c.Cover == "storm" .OrderByDescending(a => a.UploadDate) .Distinct() select (c.Name); if (!data.Any()) { var message = string.Format("No data found"); return Request.CreateErrorResponse(HttpStatusCode.NotFound, message); } return Request.CreateResponse(HttpStatusCode.OK, new {data }); }
var data = (from c in db.data_qy where c.UploadDate == yesterday && c.Cover == "storm" select (c.Name)).OrderByDescending(a => a.UploadDate).Distinct();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)