public List <Reserva> SelecionaReserva() { using (db = new ConexaoDB()) { string StrQuery = string.Format("select * from tbreserva;"); MySqlDataReader registros = db.RetornaRegistro(StrQuery); var reservaList = new List <Reserva>(); while (registros.Read()) { var ReservaTemporaria = new Reserva { IdReserva = int.Parse(registros["IdReserva"].ToString()), Mesa = new Mesa().SelecionaIdMesa(int.Parse(registros["IdMesa"].ToString())), Cliente = new Cliente().SelecionaIdCli(int.Parse(registros["IdCli"].ToString())), DataHoraReserva = DateTime.Parse(registros["DataHoraReserva"].ToString()), //HoraQueroComer = DateTime.Parse(registros["DataQueroComer"].ToString()) }; reservaList.Add(ReservaTemporaria); } return(reservaList); } }