Remove/prevent duplicated Elements from a join in LINQ

Question

0.00/5 (No votes)

See more:

Hello , I'm new in C#/LINQ.

I have 2 xmls with a common value element. I'm combining them in C#.
Doc1.xml:

XML

<line_item_data>
	<product_Category>TKM</product_Category>
	<technology>T6FFP</technology>
	<line_item>Name_1</line_item>
	<release>2013.04</release>
	<description>Maintenance.</description>
</line_item_data>

Doc2.xml:

XML

<productVersionDetails>
    <version_id>4737</version_id>
    <product>Name_1</product>
    <version>2</version>
    <status>Retired</status>
    <owner_name>Pepe Q.</owner_name>
    <type>PML</type>
    <os>Any</os>
 </productVersionDetails>

I'm merging 2 XML per value of their Element line_item and product and only the elements with type = "PML" through a Join in LINQ :

C#

XElement query = new XElement("ArrayOfProductVersionDetails",
              from bl in XElement.Load(@"doc1.xml").Elements("line_item_data") 
             join g in XElement.Load(@"doc2.xml").Elements("productVersionDetails")
                     on (string)bl.Element("line_item") equals (string)g.Element("product")
              where ((string)g.Element("type")).Equals("PML")

 
             select new XElement("product_item",
               new XElement("version_id", (string)g.Element("version_id")),
               new XElement("technology", (string)bl.Element("technology")),
               new XElement("product", (string)g.Element("product")),
               new XElement("version", (string)g.Element("version")),
               new XElement("status", (string)g.Element("status")),
               new XElement("type", (string)g.Element("type")),
               new XElement("owner_name", (string)g.Element("owner_name")),
               new XElement("description", (string)bl.Element("description")),
               new XElement("os", (string)g.Element("os"))

             )

          );
           
           query.Save(@"XML_Merged.xml");

The problem is n the final XML appears duplicate Elements:

XML_Merged.xml:

XML

</ArrayOfProductVersionDetails>
<product_item>
  <version_id>4737</version_id>
    <product>Name_1</product>
    <version>2</version>
    <status>Retired</status>
    <owner_name>Pepe Q.</owner_name>
    <type>PML</type>
    <os>Any</os>
    <technology>T6FFP</technology>
    <description>Maintenance</description>
</product_item>
<product_item>
  <version_id>4737</version_id>
    <product>Name_1</product>
    <version>2</version>
    <status>Retired</status>
    <owner_name>Pepe Q.</owner_name>
    <type>PML</type>
    <os>Any</os>
    <technology>T6FFP</technology>
    <description> Maintenance</description>
</product_item>
</ArrayOfProductVersionDetails>

I would like to do something like distinct() statement in SQL or other better way.How could I solve this?

Posted 25-Feb-14 21:05pm

Kinna-10626331

Updated 25-Feb-14 21:07pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Vedat Ozan Oner · Accepted Answer · 2014-02-25T22:39:00

First of all, I advice you not to cast values explicitly. Instead use 'Value' property as in:

bl.Element("line_item").Value equals g.Element("product").Value

As an answer to your question, there are several ways. You can do this by making your subqueries having distinct values according to the join condition, or the result can be made distinct according to a field what you want. I would prefer the first way.

C#

var q1 = (from bl in XElement.Load(@"doc1.xml").Elements("line_item_data").GroupBy(i1 =>
                            i1.Element("line_item").Value).Select(i1 => i1.First())
                      join g in XElement.Load(@"doc2.xml").Elements("productVersionDetails").GroupBy(i1 =>
                            i1.Element("product").Value).Select(i1 => i1.First())
                              on bl.Element("line_item").Value equals g.Element("product").Value
                      select new XElement("product_item",
                        new XElement("version_id", g.Element("version_id").Value),
                        new XElement("technology", bl.Element("technology").Value),
                        new XElement("product", g.Element("product").Value),
                        new XElement("version", g.Element("version").Value),
                        new XElement("status", g.Element("status").Value),
                        new XElement("type", g.Element("type").Value),
                        new XElement("owner_name", g.Element("owner_name").Value),
                        new XElement("description", bl.Element("description").Value),
                        new XElement("os", g.Element("os").Value)
                      )).ToList();

But it still depends on according to which field you want to make it distinct. Make your decision according to your aim. In the example, I have just chosen the first record of duplicates (duplicated in its xml, not the other file), but it still may not be aligned with your intention.