Deserialize XML into simple single array

Question

I need to deserialize XML into one simple array of objects, but can't quite figure out how to do it. Here is my simplified XML:

<?xml version="1.0" encoding="Windows-1250"?>
<document>
    <datasets>
        <dataset0>
            <rows>
                <row>
                    <fields>
                        <id>1</id>
                        <name>Cat1</name>
                    </fields>
                </row>
                <row>
                    <fields>
                        <id>2</id>
                        <name>Cat2</name>
                    </fields>
                </row>                
            </rows>
        </dataset0>
    </datasets>
</document>

I've created class for the object to deserialize into

public class Category
{
    public int Id { get; set; }
    public string Name { get; set; }
}

And the deserialization code

XmlSerializer xmlSerializer = new XmlSerializer(typeof(Category[]), new XmlRootAttribute("rows"));

using (FileStream myFileStream = categoryFile.OpenRead())
{        
    var categoryArray = (Category[])xmlSerializer.Deserialize(myFileStream);
}

This obviously doesn't work, I've tried various XmlElement and XmlRoot tags, but I don't quite know what I'm doing so I stripped all that out to avoid public embarrassment. Thanks for any input.

Emre Kabaoglu · Accepted Answer · 2018-01-25 17:07:37Z

2

It seems that, the object which you want to deserialize doesn't have exact compatibility with your xml file. So, in this case it could be more flexible to use Linq to xml solution.

var xDocument = XDocument.Parse(xml);
var categoryList = xDocument.Descendants("fields").Select(x => new Category
{
    Name = x.Element("name").Value,
    Id = int.Parse(x.Element("id").Value)
});

answered Jan 25, 2018 at 17:07

Emre Kabaoglu

13.2k4 gold badges27 silver badges48 bronze badges

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

1 Comment

Xeevis Over a year ago

I didn't even consider Linq, I guess no problem using that instead, thanks!

Collectives™ on Stack Overflow

Deserialize XML into simple single array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related