public void SelectProductList(string category) { SAContext objSAContext = new SAContext(); var studentList = from c in objSAContext.Products where c.Id == 1 select c; }
// // GET: /UserProfile/ public ActionResult Results(UserProfileRequest userProfileRequest) { var context = new SAContext(); var existingProfile = context.UserProfiles.Where( x => x.FirstName == userProfileRequest.UserProfile.FirstName && x.MiddleName == userProfileRequest.UserProfile.MiddleName && x.LastName == userProfileRequest.UserProfile.LastName).SingleOrDefault(); if (existingProfile == null) { context.UserProfiles.Add(userProfileRequest.UserProfile); context.SaveChanges(); } else { userProfileRequest.ErrorMessage = "Error, user profile already exists. Please try again."; return(View("Index", userProfileRequest)); } return(View()); }