How do I write the Linq parser for this xm

See more:

XML

.NET

LINQ

C#3.5

parsing

Hello All

Please find the below XML for reference.

<?xml version="1.0" encoding="utf-16"?>
<Groups count="5">
  <Metadata>
    <FieldDefinitions>
      <FieldDefinition id="12883" name="FISMA Name" alias="Application_Name" />
      <FieldDefinition id="7448" name="Severity" alias="Severity" />
    </FieldDefinitions>
  </Metadata>
  <Group FieldId="12883" Value="Cloud IaaS">
    <Group FieldId="7448" Value="Critical">
      <Aggregates>
        <Aggregate FieldId="7448" Count="12" />
      </Aggregates>
    </Group>
    <Group FieldId="7448" Value="High">
      <Aggregates>
        <Aggregate FieldId="7448" Count="155" />
      </Aggregates>
    </Group>
    <Group FieldId="7448" Value="Medium">
      <Aggregates>
        <Aggregate FieldId="7448" Count="52" />
      </Aggregates>
    </Group>
    <Group FieldId="7448" Value="Low">
      <Aggregates>
        <Aggregate FieldId="7448" Count="61" />
      </Aggregates>
    </Group>
    <Group FieldId="7448" Value="Very Low">
      <Aggregates>
        <Aggregate FieldId="7448" Count="13" />
      </Aggregates>
    </Group>
  </Group>
  <Group FieldId="12883" Value="Monitoring">
    <Group FieldId="7448" Value="Critical">
      <Aggregates>
        <Aggregate FieldId="7448" Count="11" />
      </Aggregates>
    </Group>
    <Group FieldId="7448" Value="High">
      <Aggregates>
        <Aggregate FieldId="7448" Count="32" />
      </Aggregates>
    </Group>
    <Group FieldId="7448" Value="Medium">
      <Aggregates>
        <Aggregate FieldId="7448" Count="11" />
      </Aggregates>
    </Group>
    <Group FieldId="7448" Value="Low">
      <Aggregates>
        <Aggregate FieldId="7448" Count="15" />
      </Aggregates>
    </Group>
    <Group FieldId="7448" Value="Very Low">
      <Aggregates>
        <Aggregate FieldId="7448" Count="10" />
      </Aggregates>
    </Group>
  </Group>
  
</Groups>

End Goal is to by using Linq library I want to fetch the data in a below format of in array

Cloud ISAS
Critical
12
High
155
Medium
52
---etc
Monitoring
Critical
11
High
32
---etc

Code which I wrote:

var lv1s_val = from lv1_date in xdoc1.Descendants("Group")
                     where lv1_date.Attribute("FieldId").Value == "12883"
                      select new
                      {

                        xml_val = lv1_date.Attribute("Value").Value,

                        lv1s1 = from lv1 in xdoc1.Descendants("Group")
                                from a in lv1.Descendants("Aggregate")
                                select new
                                {
                                    fval = lv1.Attribute("Value").Value,
                                    xml_mode = a.Attribute(ff).Value
                                }
                      };

Lvls_val array is giving me only Top header : Cloud IAAS and Monitoring

and Lv1s1 is giving me all in one critical to Very low, there i want it in a loop format and the values should be in sequence else I won't be able to find in output that which critical or high etc will come under which topic.

Please suggest!!

Thanks
-mahendra