Linq to XML Document Traversal
        Posted  
        
            by Perpetualcoder
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Perpetualcoder
        
        
        
        Published on 2010-04-26T00:55:18Z
        Indexed on 
            2010/04/26
            1:03 UTC
        
        
        Read the original article
        Hit count: 459
        
linq-to-xml
|c#3.0
I have an xml document like this:
<?xml version="1.0" encoding="utf-8" ?>
<demographics>
    <country id="1" value="USA">
        <state id ="1" value="California">
            <city>Long Beach</city>
            <city>Los Angeles</city>
            <city>San Diego</city>
        </state>
        <state id ="2" value="Arizona">
            <city>Tucson</city>
            <city>Phoenix</city>
            <city>Tempe</city>
        </state>
    </country>
    <country id="2" value="Mexico">
        <state id ="1" value="Baja California">
            <city>Tijuana</city>
            <city>Rosarito</city>            
        </state>
    </country>
</demographics> 
How do I setup LINQ queries for doing things like: 1. Get All Countries 2. Get All States in a Country 3. Get All Cities inside a state of a paricular country ?
I gave it a try and I am kind of confused when to use Elements["NodeName"] and Descendants etc. I know I am not the brightest XML guy around. Is the format of the XML file even correct for simple traversal?
© Stack Overflow or respective owner