Public Function ReadXML() As Lis<small>t(Of String) Dim list As New List(Of String) Dim xmlDoc As XDocument = XDocument.Load("C:\\MappingFile.xml") Dim q = From c In xmlDoc.Descendants("Entity") Where c.Attribute("Source").Value = "E_cdclient" Select New With { .source = c.Elements("Property").Attributes("Source"), //This is one collection .target = c.Elements("Property").Attributes("Target") //This is another collection. } list = q //Here I am getting error. Return list End Function </small>
<?xml version="1.0" encoding="utf-8" ?> <Entities> <Entity Source="E_cdclient" Target="cd_client"> <Property Source="KnowledgeItemId" Target="CLIENT_CONTACT_ID"/> <Property Source="KnowledgeClientID" Target="CLIENT_CONTACT_ID"/> </Entity> <Entity Source="E_cdclientsystem" Target="cd_client_system"> <Property Source="PrimaryKnowledgeItemId" Target="0"/> <Property Source="RelatedKnowledgeId" Target="0"/> </Entity> <Entity Source="E_cdclient_cdclientcontact" Target="cd_client_contact"> <Property Source="shortdescription" Target="analysis_short_description"/> <Property Source="OWNERID" Target="REF_PROJECT_OWNER_ID"/> </Entity> <Entity Source="E_cdclient_cdquestiontype" Target="cd_questiontype"> <Property Source="" Target="analysis_short"/> <Property Source="" Target="analysis_sho"/> </Entity> </Entities>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)