Question - Explain the ExecuteXmlReader?
Answer -
The execute reader method is flexible when we need the result set in the form of an XML doucment. The ExecuteXmlReader methods returns an instance of XmlReader class.
Example:
XmlReader xmlreader = cmd.ExecuteXmlReader();
XmlDocument xdoc = new XmlDocument();
C#
Using the XmlDocument class we load the XmlReader object and save it to the File System using the Save method.