System.Data.CommandBehavior.SequentialAccess Field

Provides a way for the DataReader to handle rows that contain columns with large binary values. Rather than loading the entire row, SequentialAccess enables the DataReader to load data as a stream. You can then use the GetBytes or GetChars method to specify a byte location to start the read operation, and a limited buffer size for the data being returned.

Syntax

CommandBehavior SequentialAccess

Remarks

When you specify SequentialAccess, you are required to read from the columns in the order they are returned, although you are not required to read each column. Once you have read past a location in the returned stream of data, data at or before that location can no longer be read from the DataReader. When using the System.Data.OleDb.OleDbDataReader, you can reread the current column value until reading past it. When using the System.Data.SqlClient.SqlDataReader, you can read a column value only once.

Requirements

Namespace: System.Data
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 1.0.5000.0, 2.0.0.0