CODEWITHSUNDEEP
c#xmlwinformslinq
srivatsayb
srivatsayb

Reputation: 88

Linq to XML - Returning a subset of xml

I have an XML like below :-

<SourceXML>
<Issue ID="123">
<Fields>
<Number>5</Number>
</Fields>
</Issue>
<Issue ID="125">
<Fields>
<Number>8</Number>
</Fields>
</Issue>
<Issue ID="127">
<Fields>
<Number>11</Number>
</Fields>
</Issue>
</SourceXML>

I have to get all the Issue nodes which have number as 11 or 8(where clause filter)

I tried the below but Input will be comma seperated numbers for example 8,11

  var result= from c in XElement.Load("path").Elements("Issue")
                         where c.Element("Fields").Element("Number").Value == Input
                          select c;

Basically i want the below 

<Issue ID="125">
<Fields>
<Number>8</Number>
</Fields>
</Issue>
<Issue ID="127">
<Fields>
<Number>11</Number>
</Fields>
</Issue>

Also i want to write the result into a new xml file.

Please tell me how to go about it, i am dummy in LINQ

Upvotes: 0

Views: 689

Answers (3)

RBW_IN
RBW_IN

Reputation: 562

You are pretty close! Try this.

IEnumerable<XElement> results = from c in XDocument.Load("input.xml").Elements("SourceXML").Elements("Issue")
                                where c.Element("Fields").Element("Number").Value == "8" || c.Element("Fields").Element("Number").Value == "11"
                                select c;

XDocument resultXML = new XDocument();
resultXML.Add(new XElement("SourceXML"));
resultXML.Element("SourceXML").Add(results);
resultXML.Save("output.xml");

Upvotes: 0

amaca
amaca

Reputation: 1480

Lazarus's answer gives you what you need. To write it to a new xml file, create a new XElement and save it:

XElement answer = new XElement("Results", result);
answer.Save( fileName );

Upvotes: 0

Lazarus
Lazarus

Reputation: 43124

You could try:

string[] values = Input.Split(new char[] { ',' });
var result= from c in XElement.Load("path").Elements("Issue")
                where values.Contains(c.Element("Fields").Element("Number").Value)
                select c;

Upvotes: 2

Related Questions