Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

ExecuteTable(CommandBehavior) method

UL Ext.: Retrieves, with the specified command behavior, a database table for direct manipulation. The ULCommand.CommandText is interpreted as the name of the table and ULCommand.IndexName can be used to specify a table sorting order.

Visual Basic

Public Function ExecuteTable( _
ByVal cmdBehavior As CommandBehavior _
) As ULTable

C#

public ULTable ExecuteTable(
CommandBehavior cmdBehavior
);

• 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.

The table as a ULTable object.

The ULCommand.CommandType must be set to System.Data.CommandType.TableDirect.

If the ULCommand.IndexName is a null reference (Nothing in Visual Basic), the primary key is used to open the table. Otherwise, the table is opened using the ULCommand.IndexName value as the name of the index by which to sort.

• ULCommand class
• ULCommand members
• ExecuteTable methods
• ExecuteTable() method
• Connection property
• Transaction property
• CommandText property
• IndexName property
•  CommandBehavior
•  CommandBehavior.Default
•  CommandBehavior.CloseConnection
•  CommandBehavior.SchemaOnly
• CommandType property
•  CommandType.TableDirect