ExecuteReader(CommandBehavior) method

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

Visual Basic syntax

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

C# syntax

public new ULDataReader ExecuteReader(CommandBehavior cmdBehavior)

Parameters

cmdBehavior A bitwise combination of System.Data.CommandBehavior flags describing the results of the query and its effect on the connection. UltraLite.NET respects only the System.Data.CommandBehavior.Default, System.Data.CommandBehavior.CloseConnection, and System.Data.CommandBehavior.SchemaOnly flags.

Exceptions

ULException class A SQL error occurred.
InvalidOperationException The command is in an invalid state. Either the ULCommand.Connection value is missing or closed, the ULCommand.Transaction value does not match the current transaction state of the connection, or the ULCommand.CommandText value is invalid.

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

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

SELECT statements are marked as read-only by default for performance reasons. If the query is going to be used to make updates, the statement must end with " FOR UPDATE".

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

ExecuteReader(CommandBehavior) method

Visual Basic syntax

C# syntax

Parameters

Returns

Exceptions

Remarks

See also