Export (0) Print
Expand All

SqlDataReader.GetXmlReader Method

.NET Framework 4.5

Retrieves data of type XML as an XmlReader.

Namespace:  System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

public virtual XmlReader GetXmlReader(
	int i


Type: System.Int32

The value of the specified column.

Return Value

Type: System.Xml.XmlReader
The returned object.


The connection drops or is closed during the data retrieval.

The SqlDataReader is closed during the data retrieval.

There is no data ready to be read (for example, the first Read hasn't been called, or returned false).

Trying to read a previously read column in sequential mode.

There was an asynchronous operation in progress. This applies to all Get* methods when running in sequential mode, as they could be called while reading a stream.


Trying to read a column that does not exist.


The returned type was not xml.

The XmlReader object returned by GetXmlReader does not support asynchronous operations. If you require asynchronous operations on an XmlReader, cast the XML column to an NVARCHAR(MAX) on the server and use GetTextReader with Create.

SqlException exceptions raised from XmlReader are thrown as XmlException exceptions; check the inner exception for the SqlException.

GetChars will raise an InvalidOperationException exception when used on an object returned by GetXmlReader when SequentialAccess is in effect.

For more information, see SqlClient Streaming Support.

.NET Framework

Supported in: 4.6, 4.5

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

© 2014 Microsoft