I am reading data from several database tables into a dataset and writing it to xml file using DataSet.WriteXML() method - overall the file size could be 7-10mb. For the most part this works fine, however, on few occasions it has been noticed that only partial data is written to xml, or letter's are missing from tags (like: <TransID>1001</T ansID>).
No exception is thrown - the error is realized only when next time the file is read.
I would also like to know whether,
1) DataSet.WriteXML() has limitation in terms of the file size? and, can we somehow verify whether the data written by WriteXML() is complete?
2) Is there any other safer way to write the data from the database to xml file?
Thanks in advance,