AdsCommand.ExecuteExtendedReader( CommandBehavior )

Executes AdsCommand.CommandText and returns an AdsExtendedReader with the result set based on the CommandBehavior value.

public AdsExtendedReader ExecuteReader( CommandBehavior behavior );

Remarks

Depending on the CommandBehavior value, this method executes the SQL statement or stored procedure, or opens the table that is specified in the CommandText property.

AdsExtendedReader is derived from AdsDataReader and offers an extended feature set that includes advanced table navigation, indexed searches, scopes, filters, locks and direct data manipulation. Use ExecuteExtendedReader to obtain an AdsExtendedReader object. Use ExecuteReader to obtain a standard AdsDataReader object.

The CommandBehavior values that affect the AdsExtendedReader are shown in the following table. Bitwise combinations of these values can be used.

Member Name	Description
CloseConnection	When the command is executed, the associated Connection object is closed when the associated DataReader object is closed.
Default	Default sets no CommandBehavior flags, so calling ExecuteReader(CommandBehavior.Default) is functionally equivalent to calling ExecuteExtendedReader().
KeyInfo	The query returns column and primary key information.
SchemaOnly	The query returns column information only. No result set is returned.
SingleRow	The query is expected to return a single row. The Advantage .NET Data Provider will return multiple rows if requested by Read operations, but it will not be as efficient because the provider will use a smaller read cache size when this option is specified.

Example

See ExecuteReader(CommandBehavior)