public void Update(Candidate candidate)
 {
     using var ctx = new CandidateTrackerDbContext(_connectionString);
     ctx.Candidates.Attach(candidate);
     ctx.Entry(candidate).State = EntityState.Modified;
     ctx.SaveChanges();
 }
 public void AddCandidate(Candidate candidate)
 {
     using var ctx = new CandidateTrackerDbContext(_connectionString);
     ctx.Candidates.Add(candidate);
     ctx.SaveChanges();
 }