|
UL Ext.: Retrieves, with the specified command behavior, a database table for direct manipulation. The table is opened (sorted) using the specified index.
Visual Basic
Overloads Public Function ExecuteTable( _
ByVal tableName As String, _
ByVal indexName As String, _
ByVal cmdBehavior As CommandBehavior _
) As ULTable
C#
public ULTable ExecuteTable(
string tableName,
string indexName,
CommandBehavior cmdBehavior
);
tableName The name of the table to open.
indexName The name of the index with which to open (sort) the table.
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.
This method is a shortcut for the ULCommand.ExecuteTable(System.Data.CommandBehavior) that does not require a ULCommand instance. It is provided to help users porting from earlier versions of UltraLite.NET (it replaces iAnywhere.UltraLite.Connection.GetTable() and iAnywhere.UltraLite.Table.Open()).
ULException class - A SQL error occurred.
![[external link]](gif/external.gif)
InvalidOperationException - The tableName is invalid.
The following code opens the table named MyTable using the index named MyIndex. It assumes an open ULConnection instance called conn.
' Visual Basic
Dim t As ULTable = conn.ExecuteTable( _
"MyTable", "MyIndex", CommandBehavior.Default _
)
' The line above is equivalent to
' Dim cmd As ULCommand = conn.CreateCommand()
' cmd.CommandText = "MyTable"
' cmd.IndexName = "MyIndex"
' cmd.CommandType = CommandType.TableDirect
' Dim t As ULTable = cmd.ExecuteTable(CommandBehavior.Default)
' cmd.Dispose()
// C#
ULTable t = conn.ExecuteTable(
"MyTable", "MyIndex", CommandBehavior.Default
);
// The line above is equivalent to
// ULTable t;
// using(ULCommand cmd = conn.CreateCommand())
// {
// cmd.CommandText = "MyTable";
// cmd.IndexName = "MyIndex";
// cmd.CommandType = CommandType.TableDirect;
// t = cmd.ExecuteTable(CommandBehavior.Default);
// }