I have the following XML string:
<rows>
<row>
<id>
<old>2125</old>
</id>
<name>
<old>test</old>
</name>
<amount>
<old>62</old>
</amount>
</row>
</rows>
Can Linq be used to transform the above into a list of the following class:
public class Row
{
public int Id;
public string Fields;
}
where Fields will contain the above row in this format:
id|2125^name|text^amount|62
Using linq to XML and a bit of foreach loop, you could try as below.
var str = @"<rows>
<row>
<id>
<old>2125</old>
</id>
<name>
<old>test</old>
</name>
<amount>
<old>62</old>
</amount>
</row>
</rows>";
var elements = XElement.Parse(str);
var rows = elements.Elements("row");
var list = new List<Row>();
foreach(var row in rows)
{
var id = Int32.Parse(row.Element("id").Element("old").Value);
var name = row.Element("name").Element("old").Value;
var amount = row.Element("amount").Element("old").Value;
var fields = string.Format("id|{0}^name|{1}^amount|{2}",id, name, amount);
list.Add(new Row { Id = id, Fields = fields});
}
}
I believe that in your case XmlSerialization is what you are looking for. Below is an examlpe :
namespace consoleApp {
[XmlRoot()]
public class EventInput {
private string group;
public string Group {
get { return group; }
set { group = value; }
}
private Event[] events;
public Event[] Events {
get { return events; }
set { events = value; }
}
}
public class Event {
private int id;
[XmlAttribute]
public int Id {
get { return id; }
set { id = value; }
}
}
class Program {
public static void Main() {
string xml = @"
<EventInput>
<Group>12345</Group>
<Events>
<Event Id=""100"" />
<Event Id=""101"" />
<Event Id=""102"" />
<Event Id=""103"" />
<Event Id=""104"" />
</Events>
</EventInput>";
XmlSerializer serializer = new XmlSerializer(typeof(EventInput));
EventInput ei = (EventInput)serializer.Deserialize(new StringReader(xml));
Console.WriteLine(ei.Group);
foreach(Event e in ei.Events) {
Console.WriteLine(e.Id);
}
Console.WriteLine("\n=============================\n");
ei = new EventInput() {
Group = "1111",
Events = new Event[] {
new Event() { Id = 3},
new Event() { Id = 7},
new Event() { Id = 10}}
};
serializer.Serialize(Console.Out, ei);
}
}
}
In case of more complicated xml documents - if you have schema - you can use xsd.exe to auto-generate the class hierarchy for you. For more details about XmlSerialization attributes take a look here: http://msdn.microsoft.com/en-us/library/83y7df3e(VS.85).aspx
Hope this helps
Linq itself wont do it but if you use an XMLDocument or some other XML interpreter to parse the XML into an object collection then your can use linq to read the collection
https://msdn.microsoft.com/en-us/library/system.xml.xmldocument%28v=vs.110%29.aspx
so
var rows = from d in xmlDoc.ChildNodes
where d.Name = "row"
select new {id= d.Attributes.FirstOrDefault(a=>a.Name=="id"),Other=d.Attributes.Where(a=>a.Name!="id");
var xml = XDocument.Parse(s);. If I can use Linq in a CLR function then using Linq is not a problem.