CommandType property

Specifies the type of command to be executed.

Visual Basic
Public Overrides Property CommandType As CommandType

C#
public override 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.