LINQ to XML question

[Matthias S.]

hello,

i've got the following xml structure:

<catalog>
<books>
<item key="" value="" />
<item key="" value="" />
...
</books>
<cds>
<item key="" value="" />
<item key="" value="" />
...
</cds>
</catalog>

now i'd like to build a query which will select all <itemelements in
a given section (e.g. books). i don't manage to get this straight. as
well i can't figure out how to retrieve the count on a anonymous
type/collection returned from a linq query. my linq book is ordered and
on its way, but not here yet. :)

could anyone please shed some light? thanks in advance.

matthias
--

[Martin Honnen]

Matthias S. wrote:

i've got the following xml structure:

<catalog>
<books>
<item key="" value="" />
<item key="" value="" />
...
</books>
<cds>
<item key="" value="" />
<item key="" value="" />
...
</cds>
</catalog>

now i'd like to build a query which will select all <itemelements in
a given section (e.g. books).

XDocument doc = XDocument.Load( @"catalog.xml") ;
IEnumerable<XEl ementbookItems =
doc.Root.Elemen t("books").Elem ents("item");
IEnumerable<XEl ementcdItems =
doc.Root.Elemen t("cds").Elemen ts("item");

That simply selects the 'item' XElement objects. If you want to populate
some anonymous type then do it like this:

XDocument doc = XDocument.Load( @"..\..\XMLFile 1.xml");

var query =
from item in doc.Root.Elemen t("books").Elem ents("item")
select new { key = (string)item.At tribute("key"), value
= (string)item.At tribute("value" ) };

foreach (var item in query)
{
Console.WriteLi ne("{0}: {1}.", item.key, item.value);
}
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Matthias S.]

that helped. thank you a ton.
--

Martin Honnen wrote:

Matthias S. wrote:

i've got the following xml structure:

<catalog>
<books>
<item key="" value="" / <item key="" value="" />
...
</books>
<cds>
<item key="" value="" / <item key="" value="" />
...
</cds>
</catalog>
now i'd like to build a query which will select all <itemelements
in a given section (e.g. books).

XDocument doc = XDocument.Load( @"catalog.xml") ;
IEnumerable<XEl ementbookItems =
doc.Root.Elemen t("books").Elem ents("item");
IEnumerable<XEl ementcdItems =
doc.Root.Elemen t("cds").Elemen ts("item");

That simply selects the 'item' XElement objects. If you want to
populate some anonymous type then do it like this:

XDocument doc = XDocument.Load( @"..\..\XMLFile 1.xml");

var query =
from item in
doc.Root.Elemen t("books").Elem ents("item") select new
{ key = (string)item.At tribute("key"), value =
(string)item.At tribute("value" ) };

foreach (var item in query)
{
Console.WriteLi ne("{0}: {1}.", item.key, item.value);
}