Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article provides supplementary remarks to the reference documentation for this API.
The CommandBehavior values are used by the ExecuteReader method of IDbCommand and any implementing classes.
A bitwise combination of these values may be used.
CommandBehavior is ignored when used to define a SqlNotificationRequest or SqlDependency and should therefore not be used. Use the constructor that does not require a CommandBehavior parameter in these two cases.
Notes on individual enumeration members
When using KeyInfo, .NET Framework Data Provider for SQL Server precedes the statement being executed with SET FMTONLY OFF and SET NO_BROWSETABLE ON. Users should be aware of potential side effects, such as interference with the use of SET FMTONLY ON statements. For more information, see SET FMTONLY (Transact-SQL).
Note
Use SequentialAccess to retrieve large values and binary data. Otherwise, an OutOfMemoryException might occur and the connection will be closed.
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 OleDbDataReader, you can reread the current column value until reading past it. When using the SqlDataReader, you can read a column value only once.
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
