How to loop in a Linq to XML expression

Question

How can i do this:

XDocument xDocument = new XDocument(new XElement("SqlInstall",
            new XElement("Catalogs",
                    new XElement("Install"),
                    foreach (var item in packagedProduct.Installs)
                    {
                            new XElement("File ")..
                    }

                    ))));

He complains about a foreach loop in a Linq expression with an "invalid foreach expression"

Answer 1

The foreach loop should be rewritten as follows:

packagedProduct.Installs.Select( item => new XElement("File ").. );