OdbcCommand.ExecuteReader Method (CommandBehavior)
Assembly: System.Data (in System.Data.dll)
If you expect your SQL statement to return only a single row, specifying SingleRow as the CommandBehavior value may improve application performance.
The SequentialAccess value of CommandBehavior is not a limiting setting; it just means that you will have at least sequential access to the OdbcDataReader. For example, when you use the SQL Server ODBC Driver in SequentialAccess mode, you can still move to the first column of an OdbcDataReader row after having read through all the other columns sequentially.
While the OdbcDataReader is used, the associated OdbcConnection is busy serving the OdbcDataReader. While in this state, no other operations can be performed on the OdbcConnection other than closing it. This is the case until you call the OdbcDataReader.Close method. If the OdbcDataReader is created with CommandBehavior set to CloseConnection, closing the OdbcDataReader closes the connection automatically.
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.