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