XML parsing C# using LINQ

Question

How do you parse this kind of XML file with LINQ?

<houses>
  <house nbr="146" city="Linköping" owner="john"/>
  <house nbr="134" city="Norrköping" owner="wayne"/>
  <house nbr="146" city="Köping" owner="steffe"/>
</houses>

All examples I can find only describe how to parse when each element has a value.

If this was the case I would have done it like this:

var houses = from house in xmlDoc.Descendants("house")
            select new RowData
            {
                number = spec.Element("nbr").Value,
                city = spec.Element("city").Value,
                owner = spec.Element("owner").Value,
            };
return houses ;

But this xml file is not formatted that way.

Each element provides a collection of attributes that you can use in a LINQ query. Show us how you read the elements in your code. — toniedzwiedz
– toniedzwiedz, Commented Nov 11, 2012 at 15:36

mveith · Accepted Answer · 2012-11-11 15:49:04Z

1

Try this:

var houses = from house in document.Descendants("house")
                select new RowData
                {
                    number = (int)house.Attribute("nbr"),
                    city = (string)house.Attribute("city"),
                    owner = (string)house.Attribute("owner")
                };

edited Nov 11, 2012 at 15:49

answered Nov 11, 2012 at 15:41

mveith

4771 gold badge4 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

XML parsing C# using LINQ

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related