Read an xml upto the size of 20 mb and assign it to a list of class

Question

I have an xml which is upto 20 mb:

<Neighborhood>
<Code LocationID='27767' NeighborhoodName='Broadway-Times Square' Latitude='40.7586' Longitude='-73.988152'/>
<Code LocationID='27767' NeighborhoodName='Midtown East' Latitude='40.755645' Longitude='-73.967428'/>
</Neighborhood>

I want to read the xml and create a list of class.

The class is as follows :

public class HotelNeighbourhood
{
  public int LocationID { get; set; }
  public string NeighborhoodName { get; set; }
  public float Latitude { get; set; }
  public float Longitude { get; set; }
}

I want create a list in a fastest possible manner. Thanks in advance.

Questions concerning problems with code you've written must describe the specific problem and include valid code to reproduce it. See [SSCCE.org](http://sscce.org/) for guidance. — DGibbs, Jul 10 '13 at 08:52
please read : http://stackoverflow.com/questions/12931769/c-sharp-and-reading-large-xml-files and http://stackoverflow.com/questions/7671958/reading-large-xml-documents-in-net and http://stackoverflow.com/questions/468948/in-c-sharp-what-is-the-best-way-to-parse-large-xml-size-of-1gb — Sabilv, Jul 10 '13 at 09:00

score 1 · Answer 1 · edited May 23 '17 at 10:32

1

Have a look at this, this will work whereas not sure if it is the fastest approach.

edited May 23 '17 at 10:32

Community

1
1

answered Jul 10 '13 at 08:59

Vinay Pandey

8,589
9
36
54

1

+1. How could I forget about serialization... – MarcinJuraszek Jul 10 '13 at 09:00
3

Better than forgetting about Dre. – dav_i Jul 10 '13 at 09:00

score 0 · Answer 2 · answered Jul 10 '13 at 08:57

You should search for XmlReader class usage. It's the fastest way to gain read-only access to XML file, especially when the file is big. It reads one element at the time, so you don't need to load whole document at once.

You could also check LINQ to XML. It's more developer-friendly, but unfortunately requires loading whole XML into memory, what could cause problem when file is large.

DGibbs · Accepted Answer · 2013-07-10T09:22:54.657

This does what you want

 var query = (from n in xml.Descendants("Code")
              select new HotelNeighbourhood()
              {
                   LocationID = Convert.ToInt32(n.Attribute("LocationID").Value),
                   NeighborhoodName = n.Attribute("NeighborhoodName").Value,
                   Longitude = float.Parse(n.Attribute("Longitude").Value),
                   Latitude = float.Parse(n.Attribute("Latitude").Value)

              }).ToList();

Will give you a List<HotelNeighborhood>.

score 0 · Answer 4 · answered Jul 10 '13 at 09:38

reader = new XmlTextReader(_XMLUrlPath + "indexNeighbourhood.xml"); while (reader.Read()) { if (reader.NodeType == XmlNodeType.Element && reader.Name == "Code") { HotelNeighbourhood hotelNeighbourhood = new HotelNeighbourhood(); hotelNeighbourhood.LocationID = int.Parse(reader.GetAttribute("LocationID").ToString()); hotelNeighbourhood.NeighborhoodName = reader.GetAttribute("NeighborhoodName").ToString(); hotelNeighbourhood.Latitude = reader.GetAttribute("Latitude").ToString() != string.Empty ? float.Parse(reader.GetAttribute("Latitude").ToString()) : 0; hotelNeighbourhood.Longitude = reader.GetAttribute("Longitude").ToString() != string.Empty ? float.Parse(reader.GetAttribute("Longitude").ToString()) : 0; LstHNeighbourHood.Add(hotelNeighbourhood); } } reader.Close(); reader = null; path

Read an xml upto the size of 20 mb and assign it to a list of class

4 Answers4