Executes a SQL SELECT statement with the specified command behavior and returns the result set.

Syntax

Visual Basic

Public Function ExecuteReader( _
   ByVal cmdBehavior As CommandBehavior _
) As ULDataReader

C#

public ULDataReader ExecuteReader(
   CommandBehavior cmdBehavior
);

Parameters

Return value

The result set as a ULDataReader object.

Remarks

The statement is the current ULCommand object, with the ULCommand.CommandText and any ULCommand.Parameters as required. The ULDataReader object is a read-only result set. For editable result sets, use ULCommand.ExecuteResultSet(CommandBehavior), ULCommand.ExecuteTable(CommandBehavior), or a ULDataAdapter.

If the ULCommand.CommandType is System.Data.CommandType.TableDirect, ExecuteReader performs an ULCommand.ExecuteTable(CommandBehavior) and returns a ULTable downcast as a ULDataReader.

It is recommended that SELECT statements used with this method to create read-only result sets end with FOR READ ONLY. For some statements that use temporary tables, there may be a significant performance improvement.

This is the strongly-typed version of System.Data.IDbCommand.ExecuteReader(System.Data.CommandBehavior) and System.Data.Common.DbCommand.ExecuteReader(System.Data.CommandBehavior).

See also

• ULCommand class
• ULCommand members
• ExecuteReader methods
• ExecuteReader() method
• CommandText property
• Parameters property
• ULDataReader class
• ExecuteResultSet(CommandBehavior) method
• ExecuteTable(CommandBehavior) method
• ULDataAdapter class
• CommandType property
•  CommandType.TableDirect
• ExecuteTable(CommandBehavior) method
• ULTable class
• ULDataReader class
•  IDbCommand.ExecuteReader
•  DbCommand.ExecuteReader
•  CommandBehavior
•  CommandBehavior.Default
•  CommandBehavior.CloseConnection
•  CommandBehavior.SchemaOnly
• Connection property
• Transaction property
• CommandText property