public List <Foto> FindAll() { string cadenaFindAll = "SELECT ruta FROM Foto"; List <Foto> listaFotos = new List <Foto>(); using (SqlConnection cn = BdSQL.Conectar()) { using (SqlCommand cmd = new SqlCommand(cadenaFindAll, cn)) { cn.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader != null) { while (reader.Read()) { Foto unaF = new Foto(); //unaF.Load(reader); if (unaF.Validar()) { listaFotos.Add(unaF); } } } } } return(listaFotos); }