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);
        }