CommandBehavior Enum 
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Describes of the results of the query and its effect on the database.
public enum class CommandBehaviorpublic enum CommandBehaviortype CommandBehavior = Public Enum CommandBehavior- Inheritance
- 
				CommandBehavior
Fields
| Name | Value | Description | 
|---|---|---|
| SingleResult | 1 | The query returns a single result set. Execution of the query may affect the database state. | 
| SchemaOnly | 2 | The query returns column information only, and does not affect the database state. | 
Remarks
The CommandBehavior values are used by the ExecuteReader method of the IDbCommand class and any classes derived from it.
A bitwise combination of these values may be used.