How to read the child nodes in xml file with xml reader without loading in memory

Question

1.00/5 (1 vote)

See more:

I have a xml file containing tags like

XML

<properties>
   <Property><propertyid>12345-CH1612111490</propertyid>
   <lastUpdateDate>2015-04-15</lastUpdateDate>
   <category>Residential For Rent</category>
</Property>
<Property>
  <propertyid>12345-CH1545111176</propertyid>
  <lastUpdateDate>2015-04-15</lastUpdateDate>
  <category>Residential For Rent</category>
</Property>
....n
</properties>

How can we process each <property> tag one by one with xmlReader or xmltextreader like we do with xmlnodeList by xmldocument.
We don't want to load the full xml in memory so we require the with reader.
Please help as soon as possible.

Thanks in advance.

Posted 28-Sep-15 3:32am

Member 11680870

Updated 28-Sep-15 5:29am

Maciej Los

v3

Add a Solution

Comments

[no name] 28-Sep-15 10:14am

Have a look to this: http://stackoverflow.com/questions/2441673/reading-xml-with-xmlreader-in-c-sharp[^]

Maciej Los 28-Sep-15 11:32am

Sorry, but what you mean by "How can we process each tab one by one (...) We don't want to load the full xml in memory (..)"?
You mean you want to get single node?

Member 11680870 29-Sep-15 0:20am

I mean to say that i want to apply some king of loop to <properties> tag which can read its <Property></property> tag one by one for each Property

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Accepted Answer · 2015-09-28T06:10:00

Solution 1

You can achieve reading without holding the whole object graph in memory by using System.Xml.XmlReader (using just this base class will be quite enough), and the usage can be easily figured out from the documentation: https://msdn.microsoft.com/en-us/library/system.xml.xmlreader%28v=vs.110%29.aspx[^].

If you cannot read and understand documentation to the degree which allows you to solve this simple problem, I'll regret to say that I cannot lend you my eyes.
If you have some particular problem, you probably need to ask some more special question, starting with informing us: what have you tried so far?

—SA

Posted 28-Sep-15 6:10am

Sergey Alexandrovich Kryukov

Comments

Maciej Los 28-Sep-15 12:16pm

5ed!

Sergey Alexandrovich Kryukov 28-Sep-15 12:48pm

Thank you, Maciej.
—SA

Member 11680870 29-Sep-15 0:23am

I mean to say that i want to apply some king of loop to <properties> tag which can read its <Property></Property> tag one by one for each Property.

Sergey Alexandrovich Kryukov 29-Sep-15 14:19pm

I understand that. Please see the code sample with full while "(await reader.ReadAsync())" loop, in the MSDN article I referenced. This should be your main loop. In the loop, check the node type and tag name for element nodes, and then get the data, ignoring all other nodes.

That's all. Will you accept the answer formally now?

—SA