Export (0) Print
Expand All

DbDataReader.GetStream Method

.NET Framework 4.5

Retrieves data as a Stream.

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

public virtual Stream GetStream(
	int ordinal
)

Parameters

ordinal
Type: System.Int32

Retrieves data as a Stream.

Return Value

Type: System.IO.Stream
The returned object.

ExceptionCondition
InvalidOperationException

The connection drops or is closed during the data retrieval.

The DbDataReader 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).

Tried 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.

IndexOutOfRangeException

Trying to read a column that does not exist.

InvalidCastException

The returned type was not one of the types below:

  • binary

  • image

  • varbinary

  • udt

GetStream only supports the retrieval of values that can be converted to byte arrays.

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.

Show:
© 2014 Microsoft