How to use LinqToXml for a report

[EDN Admin]

I have the following type of xml data;
<session>
<data table="Customer" key="1" op="new
<field name="First Name" type="string John</field>
<field name="Last Name" type="string Doe</field>
<field name="ID" type="integer 123</field>
</data>
<data table="Customer_Order" key="1" fkey="2" op="new"/>
<data table="Order" key="2" op="new
<field name="Description" type="string This is the order desc</field>
<field name="Date" type="date 2013/01/01</field>
<field name="quantity" type="integer 22</field>
</data>
</session>
I need to report on this data. What would be the best way to query this
xml data for reporting purposes so that I can report on it.
The column headers for this example would be like;
FirstName,LastName,ID,OrderKey,OrderDescription,OrderDate,OrderQuantity.

(but the xml really will have hundreds of different table names in it all with different field names,
so somehow I need to build objects for each one that I can query).

View the full article