CommandType property

Specifies the type of command to be executed.

Public Overrides Property CommandType As CommandType

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.