Public Function ExecuteTable(
     ByVal tableName As String,
    ByVal indexName As String,
    ByVal cmdBehavior As CommandBehavior
) As ULTable

public ULTable ExecuteTable(
     string tableName,
    string indexName,
    CommandBehavior cmdBehavior
)

The table as a ULTable object.

The table is opened (sorted) using the specified index.

This method is a shortcut for the ULCommand.ExecuteTable(System.Data.CommandBehavior) method that does not require a ULCommand object. It is provided to help users porting from earlier versions of UltraLite.NET (it replaces iAnywhere.UltraLite.Connection.GetTable and iAnywhere.UltraLite.Table.Open methods).

• ULConnection.ExecuteTable method [UltraLite.NET]
• ULTable class [UltraLite.NET]
• ULCommand class [UltraLite.NET]
•  System.Data.CommandBehavior
•  System.Data.CommandBehavior.Default
•  System.Data.CommandBehavior.CloseConnection
•  System.Data.CommandBehavior.SchemaOnly

The following code opens the table named MyTable using the index named MyIndex. It assumes an open ULConnection object named conn.

' Visual Basic
Dim t As ULTable = conn.ExecuteTable( _
    "MyTable", "MyIndex", CommandBehavior.Default _
)

' The line above is equivalent to the following code:
' 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()

The following code is the C# language equivalent:

// C#
ULTable t = conn.ExecuteTable(
    "MyTable", "MyIndex", CommandBehavior.Default
);

// The line above is equivalent to the following code:
// ULTable t;
// using(ULCommand cmd = conn.CreateCommand())
// {
//     cmd.CommandText = "MyTable";
//     cmd.IndexName = "MyIndex";
//     cmd.CommandType = CommandType.TableDirect;
//     t = cmd.ExecuteTable(CommandBehavior.Default);
// }