static void Main(string[] args) { SqlConnection connection = new SqlConnection(@"Data Source = LENOVO - PC\HUMBERBRIDGING; Initial Catalog = JOB_PORTAL_DB;Integrated Security = True; "); using (connection) { connection.Open(); string query = "select * from Applicant_Educations"; SqlCommand cmd = new SqlCommand(query, connection); ApplicantEducation[] applicantEducations = new ApplicantEducation[1000]; int index = 0; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ApplicantEducation edu = new ApplicantEducation(); edu.Id = (Guid)reader[0]; //[0]=["Id"] edu.Applicant = (Guid)reader["Applicant"]; edu.Major = (string)reader["Major"]; edu.Start_Date = (DateTime)reader["Start_Date"]; applicantEducations[index] = edu; index++; } } }
private ApplicantEducationPoco TranslateFromProto(ApplicantEducation proto) { return(new ApplicantEducationPoco { Id = Guid.Parse(proto.Id), Applicant = Guid.Parse(proto.Applicant), Major = proto.Major, CertificateDiploma = proto.CertificateDiploma, StartDate = Convert.ToDateTime(proto.StartDate), CompletionDate = Convert.ToDateTime(proto.CompletionDate), CompletionPercent = (byte)proto.CompletionPercent }); }