iAnywhere.com - CommandType property

Specifies the type of command to be executed.

Visual Basic

NotOverridable Public Property CommandType As CommandType _
Implements IDbCommand.CommandType

C#

public CommandType CommandType {get;set;}

One of the System.Data.CommandType values. The default is System.Data.CommandType.Text.

Supported command types are as follows:

System.Data.CommandType.TableDirect - UL Ext.: When you specify this CommandType, the ULCommand.CommandText must be the name of a database table. You can also specify the index used to open (sort) the table with ULCommand.IndexName. Use ULCommand.ExecuteTable() or ULCommand.ExecuteReader() to access the table.
System.Data.CommandType.Text - When you specify this CommandType, the ULCommand.CommandText must be a SQL statement or query. Use ULCommand.ExecuteNonQuery to execute a non-query SQL statement and use either ULCommand.ExecuteReader() or ULCommand.ExecuteScalar to execute a query.

ArgumentException - CommandType.StoredProcedure is not supported in UltraLite.NET.