Nested LINQ to XML based on differing attributes

Question

I am trying to write a nested query as the XML document I am working with has multiple child elements. I need to access the value where the document-id attribute is “docdb”. I need to access the value where the document-id attribute is “epodoc”.

My class case_ is defined as follows:

public class case_
{
public string appNumber { get; set; }
public string appDate { get; set; }
}

Here is what I have so far:

var myCase = from theCases in allCasesXML.Descendants("exchange-document")
select new case_
{
appNumber = (string)theCases.Element("bibliographic-data").Element("application-reference").Element("document-id").Element("doc-number"),
appDate = (from p in theCases.Descendants("document-id")
where (string)theCases.Element("bibliographic-data").Element("application-reference").Element("document-id").Attribute("document-id-type") == "epodoc"
select (p.Element("date").Value)),

  };

        foreach (var case_ in myCase)
        {
            System.Windows.Forms.MessageBox.Show(case_.appDate.ToString());
        }

The XML I am working with is as follows:

<exchange-document system="ops.epo.org" family-id="8487663" country="EP" doc- number="0173444" kind="A1">
<bibliographic-data>
<publication-reference>
  <document-id document-id-type="docdb">
    <country>EP</country>
    <doc-number>0173444</doc-number>
    <kind>A1</kind>
    <date>19860305</date>
  </document-id>
  <document-id document-id-type="epodoc">
    <doc-number>EP0173444</doc-number>
    <date>19860305</date>
  </document-id>
</publication-reference>
<classification-ipc>
  <text>B27M3/06</text>
</classification-ipc>
<classifications-ipcr>
  <classification-ipcr sequence="1">
    <text>B27M   1/    04            A I                    </text>
  </classification-ipcr>
  <classification-ipcr sequence="2">
    <text>B27M   3/    04            A I                    </text>
  </classification-ipcr>
  <classification-ipcr sequence="3">
    <text>B44C   3/    12            A I                    </text>
  </classification-ipcr>
</classifications-ipcr>
<patent-classifications>
  <patent-classification sequence="1">
    <classification-scheme office="" scheme="CPC" />
    <section>B</section>
    <class>44</class>
    <subclass>C</subclass>
    <main-group>3</main-group>
    <subgroup>12</subgroup>
    <classification-value>I</classification-value>
  </patent-classification>
  <patent-classification sequence="2">
    <classification-scheme office="" scheme="CPC" />
    <section>B</section>
    <class>27</class>
    <subclass>M</subclass>
    <main-group>1</main-group>
    <subgroup>04</subgroup>
    <classification-value>I</classification-value>
  </patent-classification>
  <patent-classification sequence="3">
    <classification-scheme office="" scheme="CPC" />
    <section>B</section>
    <class>27</class>
    <subclass>M</subclass>
    <main-group>3</main-group>
    <subgroup>04</subgroup>
    <classification-value>I</classification-value>
  </patent-classification>
</patent-classifications>
<application-reference doc-id="16601238">
  <document-id document-id-type="docdb">
    <country>EP</country>
    <doc-number>85305178</doc-number>
    <kind>A</kind>
  </document-id>
  <document-id document-id-type="epodoc">
    <doc-number>EP19850305178</doc-number>
    <date>19850719</date>
  </document-id>
  <document-id document-id-type="original">
    <doc-number>85305178</doc-number>
  </document-id>
</application-reference>

I can't seem to get my query however to bring back any results.

Anirudha · Accepted Answer · 2013-10-09 17:17:23Z

1

appDate should correspond to

appDate = (from p in theCases.Descendants("document-id")
where (string)p.Attribute("document-id-type") == "epodoc"
select (p.Element("date").Value)).FirstOrDefault()

edited Oct 9, 2013 at 17:17

answered Oct 9, 2013 at 17:01

Anirudha

32.9k8 gold badges71 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Free2Rhyme2k Over a year ago

Thanks for that. I changed it slightly: appDate = (from p in theCases.Descendants("application-reference").Descendants("document-id") where (string)p.Attribute("document-id-type") == "epodoc" select (p.Element("date").Value)).FirstOrDefault()

Free2Rhyme2k · Accepted Answer · 2013-10-29 12:14:34Z

1

Based on the post by Anirudh:

appDate = (from p in theCases.Descendants("application-reference").Descendants("document-  id") 
where (string)p.Attribute("document-id-type") == "epodoc" 
select (p.Element("date").Value)).FirstOrDefault()

The change from the post by Anirudh is the addition of another call of the function:

.Descendants("document-id")

This is required as there are multiple "document-id" elements in the XML.

edited Oct 29, 2013 at 12:14

answered Oct 18, 2013 at 14:51

Free2Rhyme2k

5641 gold badge6 silver badges15 bronze badges

Collectives™ on Stack Overflow

Nested LINQ to XML based on differing attributes

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related