Unable to load XmlReader into an XmlDocument

Asked Sep 22 '15 at 06:57

Active Sep 22 '15 at 07:21

Viewed 66 times

<Response>
    <Items>
        <attributes></attributes>
    </Items>
    <Locations>
        <attributes></attributes>
    </Locations>
</Response>

I have an XML file in the format shown above.

I want to save attributes of parent Items in a separate table in the database and attributes of parent Locations in another table.

I am not able to use XmlReader element .Read(). I have been using XmlDocument.Load to initially load the reader as XmlDocument and by using doc.SelectSingleNode("//Items") will be selecting nodes and will parse through the inside information through XmlReader .

But now I am facing an issue in loading XmlReader into an XmlDocument as I get an OutOfMemoryException.

Can someone help me to solve this?

edited Sep 22 '15 at 07:21

marc_s

704,970
168
1,303
1,425

asked Sep 22 '15 at 06:57

user3383301

1,783
3
20
45

2

How big is the file? – Magnus Sep 22 '15 at 07:30
I am not storing the xml as an file i get on a response from rest api . Size will be around 120MB. – user3383301 Sep 22 '15 at 08:38
1

I think you are going to have to work with the reader directly then to avoid having to load the complete document into memory. – Magnus Sep 22 '15 at 09:00
only 120MB of data isn't enough for a `OutOfMemoryException`. – Amit Kumar Ghosh Sep 22 '15 at 09:14
@AmitKumarGhosh `XmlDocument` uses around 10x the amount of memory as the source XML, so it'll be pretty close in an x86 process. – Charles Mager Sep 22 '15 at 09:30
So what is the workaround how can i mangae it ? – user3383301 Sep 22 '15 at 09:41
1

@user3383301 Use the XmlReader to get the data you need. – Magnus Sep 22 '15 at 09:44
I have the element with different parent element and both goes to different table . How do i differentiate ? – user3383301 Sep 22 '15 at 09:48
Depending on how your larger XML is structured, the hyrbrid 'streaming' approach in the answer to [this question](http://stackoverflow.com/questions/2441673/reading-xml-with-xmlreader-in-c-sharp) may be appropriate. – Charles Mager Sep 22 '15 at 10:00

Unable to load XmlReader into an XmlDocument

0 Answers0