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. |