Load xml from file

Question

Been looking around alot to find answers to my problem. I found a great way to convert my List to an xml file, but I also want to get it back to a list.

My current xml file looks like this:

<Commands>
    <Command command="!command1" response="response1" author="niccon500" count="1237"/>
    <Command command="!command2" response="response2" author="niccon500" count="1337"/>
    <Command command="!command3" response="response3" author="niccon500" count="1437"/>
</Commands>

Generated with:

var xml = new XElement("Commands", commands.Select(x =>
                      new XElement("Command",
                      new XAttribute("command", x.command),
                      new XAttribute("response", x.response),
                      new XAttribute("author", x.author),
                      new XAttribute("count", x.count))));
            File.WriteAllText(file_path, xml.ToString());

So, how would I get the info back from the xml file?

Giorgos Betsos · Accepted Answer · 2016-10-15 08:00:22Z

1

You can use the following piece of code:

XDocument doc = XDocument.Load(@"myfile.xml");

to load the XML file into an XDocument object.

Then you can use .Descendants("Commands").Elements() to access all elements contained inside the <Commands> element and add them to a list:

 List<Command> lstCommands = new List<Command>();
 foreach(XElement elm in doc.Descendants("Commands").Elements())
 {               
     lstCommands.Add(new Command
                     {
                        command = elm.Attribute("command").Value,
                        response = elm.Attribute("response").Value,
                        author = elm.Attribute("author").Value,
                        count = int.Parse(elm.Attribute("count").Value)
                     });
 }

edited Oct 15, 2016 at 8:00

answered Oct 15, 2016 at 7:55

Giorgos Betsos

72.3k10 gold badges69 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ondrej Svejdar · Accepted Answer · 2016-10-15 07:54:12Z

When using xml for persistent storage, start with defining POC classes and decorate them with proper attributes - like

[XmlType("Command")]
public class CommandXml
{
    [XmlAttribute("command")]
    public string Command { get; set; }
    [XmlAttribute("response")]
    public string Response { get; set; }
    [XmlAttribute("author")]
    public string Author { get; set; }
    [XmlAttribute("count")]
    public int Count { get; set; }
}

[XmlRoot("Commands")]
public class CommandListXml : List<CommandXml>
{
}

And then de-serialization is simple as:

var txt = @"<Commands>
    <Command command=""!command1"" response=""response1"" author=""niccon500"" count=""1237""/>
    <Command command=""!command2"" response=""response2"" author=""niccon500"" count=""1337""/>
    <Command command=""!command3"" response=""response3"" author=""niccon500"" count=""1437""/>
</Commands>";
CommandListXml commands;
using (var reader = new StringReader(txt))
{
    var serializer = new XmlSerializer(typeof(CommandListXml));
    commands = (CommandListXml)serializer.Deserialize(reader);
}

YuvShap · Accepted Answer · 2016-10-15 08:44:10Z

1

You can use XDocument.Load method to load the document and then create command list using LINQ to XML syntax :

XDocument doc = XDocument.Load(file_path);
var commands = doc.Root.Elements("Commands").Select(e => 
                      new Command()
                      {
                        command = e.Attribute("command").Value, 
                        response = e.Attribute("response").Value,
                        author = e.Attribute("author").Value, 
                        count= int.Parse(e.Attribute("count").Value) 
                      }).ToList();

edited Oct 15, 2016 at 8:44

answered Oct 15, 2016 at 7:34

YuvShap

3,8352 gold badges13 silver badges24 bronze badges

Collectives™ on Stack Overflow

Load xml from file

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related