using (var dbcontext = new MyModel()){ var matchedRecords = dbcontext.DummyTable.Where(e => e.code.Equals(entry.code) && e.isValid.Equals(true)).ToList(); matchedRecords.ForEach(e => e.isValid = false); dbcontext.SaveChanges(); }