public IEnumerable <Candidate> Search(string email)
 {
     using (var candidateDbContext = new CandidateDbContext(connectionString))
     {
         return(candidateDbContext.Candidates.Where(c => c.Email.Contains(email)).ToList());
     }
 }
 public IEnumerable <Candidate> Find()
 {
     using (var candidateDbContext = new CandidateDbContext(connectionString))
     {
         return(candidateDbContext.Candidates.ToList());
     }
 }
        public void Save(string email)
        {
            using (var candidateDbContext = new CandidateDbContext(connectionString))
            {
                candidateDbContext.Candidates.Add(new Candidate()
                {
                    Email = email
                });

                candidateDbContext.SaveChanges();
            }
        }