Use Linq to XML (C#) to get disticnt entries

Question

0.00/5 (No votes)

See more:

Input XML File:

XML

<?xml version="1.0" encoding="utf-8" ?>
<TOP>
  <SUB1 name="AB">
    <SUB11 name="CD">
      <SUB111>
        <KV>
          <key>KEY1</key>
          <value>1234</value>
        </KV>
        <KV>
          <key>KEY1</key>
          <value>5678</value>
        </KV>
       </SUB111>
   </SUB11>
    <SUB11 name="CD">
      <SUB111>
        <KV>
          <key>KEY1</key>
          <value>1357</value>
        </KV>
        <KV>
          <key>KEY2</key>
          <value>2468</value>
        </KV>
       </SUB111>
   </SUB11>
</SUB1>
</TOP>

Need to extract all KV elements but distinct within every SUB111. Expected output list of strings:

<key>KEY1</key><value>1234</value>
<key>KEY1</key><value>1357</value>
<key>KEY2</key><value>2468</value>

Note that duplicate KEY1 in first SUB111 is eliminated

Trying something similar to below, but not successful:

C#

IEnumerable<XElement> KVs = null;
KVs = (from sub1 in xDoc.XPathSelectElements("SUB1")
       where (string)sub1.Attribute("name").Value == "AB"
       from sub11 in sub1.Elements("SUB11")
       where (string)sub11.Attribute("name").Value == "CD"
       select sub11).SelectMany(sub111 => sub111.Elements("SUB111").Elements("KV")).ToList();

Thanks in advance for your help!
Regards
S. Vikram

Posted 3-Nov-14 21:12pm

Erpizn_13

Updated 3-Nov-14 21:33pm

v3

Add a Solution

2 solutions

Solution 1

Use Distinct() after selectMany().

Posted 3-Nov-14 21:19pm

Pravuprasad

Comments

Erpizn_13 4-Nov-14 3:22am

Tried this, but did not work :( Somehow need to use 'group by' I feel, but not getting how exactly!

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Accepted Answer · 2014-11-03T21:34:00

C#

string xml = @"<?xml version=""1.0"" encoding=""utf-8"" ?>
<TOP>
<SUB1 name=""AB"">
    <SUB11 name=""CD"">
    <SUB111>
        <KV>
        <key>KEY1</key>
        <value>1234</value>
        </KV>
        <KV>
        <key>KEY1</key>
        <value>5678</value>
        </KV>
    </SUB111>
</SUB11>
    <SUB11 name=""CD"">
    <SUB111>
        <KV>
        <key>KEY1</key>
        <value>1357</value>
        </KV>
        <KV>
        <key>KEY2</key>
        <value>2468</value>
        </KV>
    </SUB111>
</SUB11>
</SUB1>
</TOP>";
XDocument doc = XDocument.Parse(xml);
var items = doc.Root.Descendants("SUB111")
                .SelectMany(s=>s.Descendants("KV")
                .GroupBy(x=>(string)x.Element("key"))
                .Select(g=>g.First()))
                .ToList();

You may need to add your where conditions but most important thing is you can group by key value and select the first item of the group, that will remove the duplicates.

Use Linq to XML (C#) to get disticnt entries

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Use Linq to XML (C#) to get disticnt entries

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us