|
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
Overloads 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.
ULException class - A SQL error occurred.
![[external link]](gif/external.gif)
InvalidOperationException - The command is in an invalid state. Either the ULCommand.Connection is missing or closed, the ULCommand.Transaction value does not match the current transaction state of the connection, or the ULCommand.CommandText is invalid.