|
| Member name | Description |
|---|---|
| ULCommand constructor |
Initializes a ULCommand object. |
| ULCommand constructor |
Initializes a ULCommand object with the specified command text. |
| ULCommand constructor |
Initializes a ULCommand object with the specified command text and connection. |
| ULCommand constructor |
Initializes a ULCommand object with the specified command text, connection, and transaction. |
| Member name | Description |
|---|---|
| CommandText property |
Specifies the text of the SQL statement or the name of the table when the ULCommand.CommandType is System.Data.CommandType.TableDirect. For parameterized statements, use a question mark (?) placeholder to pass parameters. |
| CommandTimeout property |
This feature is not supported by UltraLite.NET. |
| CommandType property |
Specifies the type of command to be executed. |
| Connection property |
The connection object on which to execute the ULCommand object. |
| DesignTimeVisible property |
Indicates if the ULCommand should be visible in a customized Windows Form Designer control. |
| IndexName property |
UL Ext.: Specifies the name of the index to open (sort) the table with when the ULCommand.CommandType is System.Data.CommandType.TableDirect. |
| Parameters property |
Specifies the parameters for the current statement. |
| Plan property |
UL Ext.: Returns the access plan UltraLite.NET uses to execute a query. This property is intended primarily for use during development. |
| Transaction property |
Specifies the ULTransaction in which the ULCommand executes. |
| UpdatedRowSource property |
Specifies how command results are applied to the DataRow when used by the Update method of the ULDataAdapter. |
| Member name | Description |
|---|---|
| Cancel method |
This method is not supported in UltraLite.NET. |
| CreateParameter method |
Provides a ULParameter object for supplying parameters to ULCommand objects. |
| ExecuteNonQuery method |
Executes a statement that does not return a result set, such as a SQL INSERT, DELETE, or UPDATE statement. |
| ExecuteReader method |
Executes a SQL SELECT statement and returns the result set. |
| ExecuteReader method |
Executes a SQL SELECT statement with the specified command behavior and returns the result set. |
| ExecuteResultSet method |
UL Ext.: Executes a SQL SELECT statement and returns the result set as a ULResultSet. |
| ExecuteResultSet method |
UL Ext.: Executes a SQL SELECT statement with the specified command behavior and returns the result set as a ULResultSet. |
| ExecuteScalar method |
Executes a SQL SELECT statement and returns a single value. |
| ExecuteTable method |
UL Ext.: Retrieves in a ULTable a database table for direct manipulation. The ULCommand.CommandText is interpreted as the name of the table and ULCommand.IndexName can be used to specify a table sorting order. |
| ExecuteTable method |
UL Ext.: Retrieves, with the specified command behavior, a database table for direct manipulation. The ULCommand.CommandText is interpreted as the name of the table and ULCommand.IndexName can be used to specify a table sorting order. |
| Prepare method |
Pre-compiles and stores the SQL statement of this command. |