public List <CourseDTO> listAllCourses() { string query = "Select * from tb_Curso"; SchoolDatabase d = new SchoolDatabase(); MySqlDataReader r = d.ExecuteSelect(query); List <CourseDTO> itens = new List <CourseDTO>(); while (r.Read()) { CourseDTO t = new CourseDTO(); t.ID = r.GetInt32("id_trab"); t.Name = r.GetString("nm_nome"); t.Phone = r.GetString("nr_telefone"); t.Address = r.GetString("nm_endereco"); t.CellPhone = r.GetString("nm_celular"); t.Renewal = r.GetInt32("nr_data"); itens.Add(t); } return(itens); }