How to parse through XML and create object in C#

Question

I want to create list of whitelist objects from the below XML.

Created a class WhiteList

class WhiteList
{
    public string ID { get; set; }
    public string From { get; set; }
    public string To { get; set; }
}

I need to create list of objects out of the XML

<Response>
  <list>
    <whitelist>
      <id>1234</id>
      <from>sdfkmsfk@wfgtitleco.com</from>
      <to>dsfgsdf@loansdfglosers.com</to>
    </whitelist>
    <whitelist>
      <id>1452</id>
      <from>mdsfgaursdfgdfmimi@gmail.com</from>
      <to>dfsgdscew@loansdfglosers.com</to>
    </whitelist>
    <whitelist>
      <id>9483</id>
      <from>prvs=17958ac559=dmcclain@wfgtitleco.com</from>
      <to>status@loansdfglosers.com</to>
    </whitelist>
    <whitelist>
      <id>5654</id>
      <from>ewrgre@loansdfglosers</from>
      <to>werferw@loansdfglosers.com</to>
    </whitelist>
  </list>
</Response>

score 2 · Answer 1 · answered Nov 20 '19 at 04:49

2

Here is a straightforward example using your XML document:

public static List<WhiteList> CreateObjects(XDocument xmldoc)
{
    var query = from data in xmldoc.Descendants("whitelist")
                select new WhiteList
                {
                    ID = (string)data.Element("id"),
                    From = (string)data.Element("from"),
                    To = (string)data.Element("to"),
                };

    var list = query.ToList();
    List<WhiteList> result = new List<WhiteList>();
    // now create the desierd list
    foreach (var x in list)
    {
        WhiteList ws = new WhiteList();
        ws.ID = x.ID;
        ws.From = x.From;
        ws.To = x.To;
        result.Add(ws);
    }

    return result;
}

answered Nov 20 '19 at 04:49

Jonathan Applebaum

5,738
4
33
52

Maybe asker should think about create a xsd schema. – DrkDeveloper Nov 20 '19 at 05:03
@DrkDeveloper why? OP already got code for this step... then OP can ask another question... (more seriously why do you think XSD would help parsing?) – Alexei Levenkov Nov 20 '19 at 05:52
@AlexeiLevenkov Not parsing, it helps making the xml files coherent to the structure you need. – DrkDeveloper Nov 20 '19 at 06:15

score 1 · Answer 2 · answered Nov 20 '19 at 05:13

A generic class that I have created for serializing and de-serializing XML to .net object and vice versa.

You need to add a helper class as below. Just change the namespace as your project.

 using System.IO;
using System.Xml.Serialization;

namespace YourProject
{
public class XMLParser<T> where T : class
{

    public static T Deserialize(string path)
    {
        T item;
        try
        {
            var serializer = new XmlSerializer(typeof(T));
            using (var reader = new FileStream(path, FileMode.Open, FileAccess.Read, FileShare.Read))
            {
                item = (T)serializer.Deserialize(reader);

                reader.Dispose();
            }
        }
        catch (System.Exception)
        {

            throw;
        }
        return item;
    }


    public static void Serialize(object item, string path)
    {
        var serializer = new XmlSerializer(typeof(T));
        using (var fs = new FileStream(path, FileMode.Create, FileAccess.ReadWrite, FileShare.ReadWrite))
        {
            using (var writer = new StreamWriter(fs))
            {
                serializer.Serialize(writer, item);
                writer.Close();
                writer.Dispose();
            }
        }
    }
}
}

Now your class is not complaint with XML so you need to change your class a bit.

class Response{
 public List<WhiteList> list{get; set;}
}
class WhiteList{
public string ID {get;set;}
public string From {get;set;}
public string To {get;set;}
}

Now you can call XMLParser class to serialize or deserialize XML or .net object. Below is the call

Just provide the path to XML

Response response = XMLParser<Response>.Deserialize([path of XML]);

How to parse through XML and create object in C#

2 Answers2