public void UpdateStatus(int id, Status status) { using (var context = new CandidateTrackerDataContext()) { context.ExecuteCommand("UPDATE Candidates SET Status = {0} where id = {1}", status, id); context.SubmitChanges(); } }
public void AddCandidate(Candidate candidate) { using (var context = new CandidateTrackerDataContext()) { context.Candidates.InsertOnSubmit(candidate); context.SubmitChanges(); } }