SqlCeCommand.CommandType Property

public override CommandType CommandType { get; set; }

/** @property */
public CommandType get_CommandType ()

/** @property */
public void set_CommandType (CommandType value)

public override function get CommandType () : CommandType

public override function set CommandType (value : CommandType)

Property Value

SQL Server Compact 3.5 SP1 supports only the Text and TableDirectCommandTypes. An unsupported exception is thrown if StoredProcedure is specified.

TableDirect is the fastest way to retrieve data from SQL Server Compact 3.5 SP1, but cannot be used with joined tables.

The Connection, CommandType, and CommandText properties cannot be set if the current connection is performing an Execute or Fetch operation.

The following example creates an instance of SqlCeCommand and sets the CommandType and other properties.

SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM Categories ORDER BY CategoryID";
cmd.CommandType = CommandType.Text;
cmd.UpdatedRowSource = UpdateRowSource.Both;

Development Platforms