public void AddCandidate(Candidate candidate)
 {
     using (var context = new CandidatesDataContext(_connectionString))
     {
         context.Candidates.InsertOnSubmit(candidate);
         context.SubmitChanges();
     }
 }