Resolved LINQ TO XML: How to get elements?

[loris04]

I have this xml structure:

<?xml version="1.0" encoding="utf-8"?>
<asx:abap xmlns:asx="http://www.sap.com/abapxml" version="1.0">
    <asx:values>
        <SALESORDER>
            <EXTENSIONIN>
                <item>
                    <CONFIRMATIONPRINTDATE />
                    <CUSTOMEROFFERNOTE />
                    <CUSTOMERREFERENCE />
                </item>
            </EXTENSIONIN>
            <ORDERCFGSVALUE>
                <item>
                    <CHARC>DRAWING_LANGUAGE_CRM</CHARC>
                </item>
                <item>
                    <CHARC>EOS_QUOT_ORD_TYPE</CHARC>
                </item>
                <item>
                    <CHARC>GRP_BRANCH_EFFICIENCY_FACTOR</CHARC>
                </item>
            </ORDERCFGSVALUE>
        </SALESORDER>
    </asx:values>
</asx:abap>

I need all elements from the elements "item" in the element "ORDERCFGSVALUE". Does anyone know what the correct LINQ query is?
I have tried these query:

items = from values in xdocument.Descendants("ORDERCFGSVALUE").Elements("item").Elements()
select values;

items = from values in xdocument.Descendants("ORDERCFGSVALUE").Descendants("item").Elements()
select values;

items = from values in xdocument.Descendants("ORDERCFGSVALUE").Descendants("CHARC")
select values;

Unfortunately I get no result.
This query works to get the items of element EXTENSIONIN:

items = from values in xdocument.Descendants("EXTENSIONIN").Elements("item").FirstOrDefault().Elements()
select values;

The result should be:

<CHARC>DRAWING_LANGUAGE_CRM</CHARC>
<CHARC>EOS_QUOT_ORD_TYPE</CHARC>
<CHARC>GRP_BRANCH_EFFICIENCY_FACTOR</CHARC>

Thank you in advance.

 

[jmcilhinney]

This worked fine for me:

            var xdocument = XElement.Parse(@"<?xml version=""1.0"" encoding=""utf-8""?>
<asx:abap xmlns:asx=""http://www.sap.com/abapxml"" version=""1.0"">
    <asx:values>
        <SALESORDER>
            <EXTENSIONIN>
                <item>
                    <CONFIRMATIONPRINTDATE />
                    <CUSTOMEROFFERNOTE />
                    <CUSTOMERREFERENCE />
                </item>
            </EXTENSIONIN>
            <ORDERCFGSVALUE>
                <item>
                    <CHARC>DRAWING_LANGUAGE_CRM</CHARC>
                </item>
                <item>
                    <CHARC>EOS_QUOT_ORD_TYPE</CHARC>
                </item>
                <item>
                    <CHARC>GRP_BRANCH_EFFICIENCY_FACTOR</CHARC>
                </item>
            </ORDERCFGSVALUE>
        </SALESORDER>
    </asx:values>
</asx:abap>");

            var query = xdocument.Descendants("ORDERCFGSVALUE").Descendants("item").Descendants("CHARC");

            var values = query.ToArray();

 

[JohnH]

All three of your "Tested queries" works for me and also get the same result as the query @jmcilhinney posted.

I used XDocument.Load to load the test data file by the way. How have you loaded your xdocument ?

 

[jmcilhinney]

Based on the XML you provided, you don't even need filters for the last two calls because there are no other elements:

var query = xdocument.Descendants("ORDERCFGSVALUE").Descendants().Descendants();

or:

var query = xdocument.Descendants("ORDERCFGSVALUE").Elements().Elements();

 

[loris04]

All three of your "Tested queries" works for me and also get the same result as the query @jmcilhinney posted.

I used XDocument.Load to load the test data file by the way. How have you loaded your xdocument ?

So did I:

 XDocument xdocument = XDocument.Load(filepath);

But the question has been clarified. Thanks.