XML : Extract data from complex XML using Linq

Hi I Have a XML Like Follows

  <Feed>  <Control>      <UserName>testUser</UserName>      <Password>testPass</Password>  </Control>  <leeds>      <leed>          <leedid>4990935</leedid>          <Reference>4990935</Reference>          <IncidentDetails>              <IncidentDate>2015-08-05</IncidentDate>              <AccidentDetails>damage</AccidentDetails>          </AccidentDetails>          <ClientDetails>              <ClientsID>4990935</ClientsID>              <ClientsName>Test Name</ClientsName>          </ClientDetails>          <IncidentDetails>              <IncidentID>557475</IncidentID>              <IncidentName>Injury</IncidentName>          </IncidentDetails>      </leed>  </leeds>    

Now I am trying to Extract Data Using the Following Linq but its not working could you please help.

  XDocument xmlDoc = XDocument.Load(path);            var results = from job in xmlDoc.Root.Elements("Control")                        let Repairer = job.Parent.Elements("Leeds").FirstOrDefault()                          select new Job {                            Username = (string)job.Element("leedid"),                            Password = (string)job.Element("Reference"),                            IncidentDetail = (string)job.Element("IncidentDetail"),                            ClientsName = (string)job.Element("ClientsName"),                            IncidentName = (string)Repairer.Element("IncidentName")                        };                        return result;    

I have Model Class

  public class job {      public string Username { get; set; }        public string Password { get; set; }        public int leedid { get; set; }        public int Reference { get; set; }        public string IncidentDate { get; set; }        public string IncidentDetail { get; set; }        public string ClientsID { get; set; }        public string ClientsName { get; set; }        public string IncidentID { get; set; }        public string IncidentName { get; set; }  }    

I am very new in Linq and XML, One Feed will have one control and multiple leeds.

No comments:

Post a Comment