XML to List

EDN Admin · Feb 16, 2012

I have the following xml that I am pulling from a service: 
 

<pre class="prettyprint" style="border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; font-size:13px; vertical-align:baseline; background-color:#f0f3f4; line-height:1.2em; min-height:35px; overflow-x:auto; overflow-y:auto; width:798px; font-family:Consolas,Courier New,Courier,monospace <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <results><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re <result><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re <displayName><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent Joe Blow<span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent </displayName><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re <department><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent Real Estate<span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent </department><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re <ape><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re <phone<span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="atn" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent type<span class="pun" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent =<span class="atv" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent "Mobile"<span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="atn" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent typeId<span class="pun" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent =<span class="atv" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent "6"<span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="atn" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent relationship<span class="pun" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent =<span class="atv" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent "Business"<span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="atn" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent relationshipId<span class="pun" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent =<span class="atv" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent "1"<span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent ><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re <formattedPhone><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent (555) 555-5555<span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent </formattedPhone><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re </phone><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re </ape><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re <additionalFields><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re <additionalField><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re <definitionId><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent 8589935558<span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent </definitionId><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re <name><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent Floor Location<span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent </name><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re <value><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent 2373<span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent </value><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re <displayValue><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent 2373<span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent </displayValue><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re </additionalField><span class="pln" style="margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re </additionalFields><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="x_Apple-tab-span" style="white-space

re </result><span class="pln" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent <span class="tag" style="color:#222222; margin-bottom:0px; padding-bottom:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; outline-width:0px; outline-style:initial; outline-color:initial; vertical-align:baseline; background-color:transparent </results>[/code]
I am using the following code: 

StreamReader reader = new StreamReader(data); 
 
XDocument xdoc = XDocument.Parse(reader.ReadToEnd()); 
 
<span class="x_Apple-tab-span" style="white-space

re var contact = from contacts in xdoc.Descendants("result") 
<span class="x_Apple-tab-span" style="white-space

re where contacts.Element("department") != null && contacts.Element("jobTitle") != null 
<span class="x_Apple-tab-span" style="white-space

re select new 
<span class="x_Apple-tab-span" style="white-space

re { 
<span class="x_Apple-tab-span" style="white-space

re displayname = contacts.Element("displayname").Value, 
<span class="x_Apple-tab-span" style="white-space

re department = contacts.Element("department").Value 
<span class="x_Apple-tab-span" style="white-space

re /*office = ?????*/<span class="x_Apple-tab-span" style="white-space

re
 
<span class="x_Apple-tab-span" style="white-space

re }
 

What I am trying to get is one list with 
 
displayname, 
department, 
office (which is stored here <additionalFields><additionalField><value>2373</value></additionalFields></additionalField> 
 
How do I modify my select to get this data? 
 
What is the best approach for this? 
 
Thanks in advance.

View the full article

XML to List

EDN Admin

Well-known member