How to parse deeply nested using LINQ to XML

Question

How do I parse the following XML using LINQ?
I need to insert into a database table OrderNumber, ShipAddress, ShipCity, ShipState for each Order & OrderCancelled.
Then in a separate table I need to insert OrderId from the Returns/Amount section.

<!-- language: lang-xml -->
<?xml version="1.0" encoding="utf-8"?>
<OrdersReport Date="2012-08-01">
<Client>
<ClientId>1</ClientId>
  <Orders>
    <Order>
      <OrderNumber>1</OrderNumber>
      <ShipAddress>123 Main St.</ShipAddress>
      <ShipCity>MyCity</ShipCity>
      <ShipState>AZ</ShipState>
    </Order>
    <Order>
      <OrderNumber>2</OrderNumber>
      <ShipAddress>111 Main St.</ShipAddress>
      <ShipCity>OtherCity</ShipCity>
      <ShipState>AL</ShipState>
    </Order>
    <OrderCancelled>
      <OrderNumber>3</OrderNumber>
      <ShipAddress>111 Main St.</ShipAddress>
      <ShipCity>OtherCity</ShipCity>
      <ShipState>AL</ShipState>
    </OrderCancelled>
  </Orders>  
  <Returns>
    <Amount>
      <OrderId>2</OrderId>
      <OrderId>3</OrderId>
    </Amount>
  </Returns> 
</Client>
<Client>
<ClientId>2</ClientId>
<!-- Same Tree structure as Client 1 -->
</Client>
</OrdersReport>

Based on the responses I got, I have updated the question.

var doc = XDocument.Load(rootFolder + "Generic.xml");
    var query = doc.Descendants("Order")
                   .Concat(doc.Descendants("OrderCancelled"))
                   .Select(x => new
                   {
                       OrderNumber = (int)x.Element("OrderNumber"),
                       ShipAddress = (string)x.Element("ShipAddress"),
                       ShipCity = (string)x.Element("ShipCity"),
                       ShipState = (string)x.Element("ShipState")
                   });           

    var amount = doc.Descendants("Amount")                         
                  .Select(y => new
                  {
                      OrderId = (int)y.Element("OrderId")
                  });

    foreach (var o in query)
    {
        Console.WriteLine(o.OrderNumber + o.ShipAddress + o.ShipCity);
    }
    foreach (var r in amount)
    {
        Console.WriteLine(r.OrderId);
    }

The amount enumeration is only giving me the first OrderId, what am I doing incorrectly?

Colors showed up after posting :-) but not still not indenting. — Picflight
– Picflight, Commented Nov 2, 2012 at 22:39

Jon Skeet · Accepted Answer · 2012-11-02 22:41:44Z

1

It sounds like you just want all the descendant Order/OrderCancelled elements:

var doc = XDocument.Load("file.xml");
var query = doc.Descendants("Order")
               .Concat(doc.Descendants("OrderCancelled"))
               .Select(x => new {
                           OrderNumber = (int) x.Element("OrderNumber"),
                           ShipAddress = (string) x.Element("ShipAddress"),
                           ShipCity = (string) x.Element("ShipCity"),
                           ShipState = (string) x.Element("ShipState")
                       });

Then you can iterate over the results, which will be a sequence of the anonymous type, and do whatever you need to insert it into the database.

answered Nov 2, 2012 at 22:41

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Picflight Over a year ago

So, I could do a similar select for the Returns?

Jon Skeet Over a year ago

@Picflight: Absolutely, although note that you've have to get each OrderId element within each Amount.

Sergey Berezovskiy · Accepted Answer · 2012-11-02 22:52:17Z

0

I think it is possible without concatenation:

var query = from o in xdoc.Descendants("Orders").Elements()
            select new 
            {
                OrderNumber = (int)o.Element("OrderNumber"),
                ShipAddress = (string)o.Element("ShipAddress"),
                ShipCity = (string)o.Element("ShipCity"),
                ShipState = (string)o.Element("ShipState")
            };

answered Nov 2, 2012 at 22:52

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

3 Comments

Jon Skeet Over a year ago

How does that satisfy "for each Order & OrderCancelled"?

Sergey Berezovskiy Over a year ago

@JonSkeet sorry, forgot to do Elements()

Jon Skeet Over a year ago

Right, that will do it - so long as there are never any other elements within Orders.

Collectives™ on Stack Overflow

How to parse deeply nested using LINQ to XML

2 Answers 2

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related