public List <Clinica> Lista(int id) { conexao.Open(); string sql = "SELECT * FROM Clinica " + (id > 0 ? "WHERE id = @id" : "") + "ORDER BY nome"; MySqlCommand comandoQuery = new MySqlCommand(sql, conexao); if (id > 0) { comandoQuery.Parameters.AddWithValue("@id", id); } MySqlDataReader reader = comandoQuery.ExecuteReader(); List <Clinica> lista = new List <Clinica>(); while (reader.Read()) { Clinica clinica = new Clinica(); clinica.Id = reader.GetInt32("Id"); if (!reader.IsDBNull(reader.GetOrdinal("Nome"))) { clinica.Nome = reader.GetString("Nome"); } if (!reader.IsDBNull(reader.GetOrdinal("Detalhes"))) { clinica.Detalhes = reader.GetString("Detalhes"); } lista.Add(clinica); } conexao.Close(); return(lista); }