protected void UpdateJobViewedCount() { var request = HttpContext.Current.Request; Uri svcUri = new Uri(Request.Url.GetLeftPart(UriPartial.Authority) + Request.ApplicationPath + "Services/TopTenWcfDataService.svc"); try { TopTenWcfDataServiceRef.JobRepoDataContext context = new TopTenWcfDataServiceRef.JobRepoDataContext(svcUri); int JobID = (request.QueryString["JJ"] != null ? Convert.ToInt32(request.QueryString["JJ"]) : 0); /*The following query will be transfered to * http://localhost:50339/Services/TopTenWcfDataService.svc/Jobs()?$filter=JobID eq 15 * http://localhost:50339/Services/TopTenWcfDataService.svc/Jobs()?$filter=JobID%20eq%2015 */ DataServiceQuery <TopTenWcfDataServiceRef.Job> jobs = context.Jobs .AddQueryOption("$filter", "JobID eq " + JobID.ToString()); var job = jobs.Single(); /* * We can get the same result using LINQ Query: * var job = (from j in context.Jobs * where j.JobID.Equals(JobID) * select j).Single(); * it will will be transfered to * http://localhost:50339/Services/TopTenWcfDataService.svc/Jobs(15) */ if (job != null) { job.Viewed += 1; context.UpdateObject(job); context.SaveChanges(); } } catch (Exception ex) { Response.Write(ex.Message); } }