How to create an XML file from a XmlReader?
You need to create an XmlWriter
and call its WriteNode
method.
For example:
using (conn)using (SqlCommand dataCmd = new SqlCommand(sqlText, Conn)) { dataCmd.CommandTimeout = 60000; Conn.Open(); using (XmlReader dataReader = dataCmd.ExecuteXmlReader()) using (XmlWriter writer = XmlWriter.Create(File.OpenWrite(...)) { writer.WriteNode(dataReader, true); }}