public bool JobCandidateDelete(JobCandidate jobcandidate)
        {
            return Execute<bool>(dal =>
            {
                JobCandidate jobcandidateDelete = dal.JobCandidate.Where(x => x.JobCandidateID == jobcandidate.JobCandidateID).FirstOrDefault();
                if (jobcandidateDelete != null)
                {
                    dal.JobCandidate.DeleteOnSubmit(jobcandidateDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool JobCandidateUpdate(JobCandidate jobcandidate)
        {
            return Execute<bool>(dal =>
               {
               JobCandidate jobcandidateUpdate = dal.JobCandidate.Where(x => x.JobCandidateID == jobcandidate.JobCandidateID).FirstOrDefault();
               if (jobcandidateUpdate != null)
               {
                   jobcandidateUpdate.JobCandidateID = jobcandidate.JobCandidateID;
                   jobcandidateUpdate.BusinessEntityID = jobcandidate.BusinessEntityID;
                   jobcandidateUpdate.Resume = jobcandidate.Resume;
                   jobcandidateUpdate.ModifiedDate = jobcandidate.ModifiedDate;

                   dal.SubmitChanges();
                   return true;
               }
               return false;

               });
        }
 partial void DeleteJobCandidate(JobCandidate instance);
 partial void UpdateJobCandidate(JobCandidate instance);
 partial void InsertJobCandidate(JobCandidate instance);
 public void JobCandidateUpdate(JobCandidate jobcandidate)
 {
     adventureWorks_BC.JobCandidateUpdate(jobcandidate);
 }