CODEWITHSUNDEEP
c#linq-to-xml
Robert Strauch
Robert Strauch

Reputation: 12896

Querying XML elements with identical name with Linq

I have the following XML:

<?xml version="1.0" encoding="UTF-8"?>
<ProductTypes>
    <ProductType Name="MyProduct">
        <Amount>100</Amount>
        <Pattern Length="1" AllowedCharacters="ABCD"/>
        <Pattern Length="7" AllowedCharacters="EFGH"/>
    </ProductType>
</ProductTypes>

Using Linq to XML I can successfully extract information from any number of the element ProductType. However I also need the information from all of the elements Pattern.

        XElement xml = XElement.Load("pattern_config.xml");

        var productTypes = from productType in xml.Elements("ProductType")
                           select new {
                               Name = productType.Attribute("Name").Value,
                               Amount = Convert.ToInt32(productType.Element("Amount").Value)
                               // How to get all Pattern elements from that ProductType?
                           };

How can I do this? Or would you recommend another way accessing this XML?

Upvotes: 0

Views: 54

Answers (1)

Henk Holterman
Henk Holterman

Reputation: 273244

You can nest queries.

 var productTypes = from productType in xml.Elements("ProductType")
                select new {
                   Name = productType.Attribute("Name").Value,
                   Amount = Convert.ToInt32(productType.Element("Amount").Value),
                   // How to get all Pattern elements from that ProductType?
                   Patterns = from patt in productType.Elements("Pattern")
                              select new { Length = int.Parse(patt.Attribute("Length").Value),
                                           .... }
                 };

Upvotes: 1

Related Questions