Merging two xml files LINQ

Question

I have problem merging two XML files. I loaded both files into two objects, located the target nodes in both objects and tried to merge.

Here is a sample:

var nodes1 = XResult1.Descendants("subject");
var nodes2 = XResult2.Descendants("subject");

//nodes1.Add(nodes2.Nodes());

//* Code to merge** Can somebody pls help me. Thanks in advance... BB

Here is my XResult1:

<subjects>
    <subject>
        <node id="1">
            Hi
        </node>
        <node id="2">
            Hi again
        </node>
        <node id="3">
            Hi once more
        </node>
    </subject>
</subjects>

Here is my XResult2 :

<subjects>
    <subject>
        <node id="4">
            Hello
        </node>
        <node id="5">
            Hello again
        </node>
    </subject>
</subjects>

And my final Result should be :

<subjects>
    <subject>
        <node id="1">
            Hi
        </node>
        <node id="2">
            Hi again
        </node>
        <node id="3">
            Hi once more
        </node>
        <node id="4">
            Hello
        </node>
        <node id="5">
            Hello again
        </node>

    </subject>
</subjects>

Russell McClure · Accepted Answer · 2011-02-08T20:32:49.410

3

You want to change:

XResult1.Descendants("subjects").FirstOrDefault(); 
XResult2.Descendants("subjects").FirstOrDefault();

to

XResult1.Descendants("subject").FirstOrDefault();
XResult2.Descendants("subject").FirstOrDefault();

Here is a more complete example:

XDocument document = XDocument.Load(@"C:\XResult1.xml");
XElement subjectElement = document.Descendants("subject").FirstOrDefault();

XDocument document2 = XDocument.Load(@"C:\XResult2.xml");
XElement subjectElement2 = document2.Descendants("subject").FirstOrDefault();

subjectElement.Add(subjectElement2.Nodes());

edited Feb 08 '11 at 20:32

answered Feb 08 '11 at 20:22

Russell McClure

4,821
1
22
22

@Russell. Thank you. My system hangs at subjectElement.Add(subjectElement2.Nodes()); – BumbleBee Feb 08 '11 at 21:32
The other thing I noted is .FirstOrDefault() returns only the first but actually i need all the . – BumbleBee Feb 08 '11 at 21:37
If you are saying you have more than one tag per XML document, then you need to update your question with the proper XML. – Russell McClure Feb 08 '11 at 22:18
Okay. So the problem with your code now is that you are not calling FirstOrDefault() as I show in my answer. My answer is correct. – Russell McClure Feb 08 '11 at 23:03

vlad · Answer 2 · 2011-02-08T21:14:33.740

0

If you want to merge the elements inside the subject element, you need to go down further in the tree, so set your nodes1 and nodes2 to the following:

XElement nodes2 = XResult2.Descendants("subjects").Descendants("subject").FirstOrDefault();

edited Feb 08 '11 at 21:14

answered Feb 08 '11 at 20:20

vlad

4,748
2
30
36

@Russell McClure you're right, for some reason I was thinking about lists. fixed. – vlad Feb 08 '11 at 21:14
FirstOrDefault() yeilds only the first element but actually I need all the elments in XResult2. – BumbleBee Feb 08 '11 at 21:42
@BumbleBee your XML files show that you have only one `` element, which in turn has many `` elements – vlad Feb 08 '11 at 23:37

Merging two xml files LINQ

2 Answers2

Linked