command class
Description
Represents a SQL statement to execute on a Sqlite database.
Notes
It is a class that is statically included in the Cooker.
An instance returned by variable declaration has not been initialized.
An instance that is used up should be released. Please do not forget to call Release() method.
fitter
Signature | Description |
command() | Returns a new instance of command class. |
command(string) | Returns a new instance of command class. |
command(connection) | Returns a new instance of command class. |
command(string,connection) | Returns a new instance of command class. |
command(string,connection,transaction) | Returns a new instance of command class. |
getter
Signature | Description |
CommandText | Returns a SQL statement. |
Fitted | Returns the value that indicates whether an instance was initialized. |
TypeName | Returns the type name. |
setter
Signature | Description |
CommandText | Sets a SQL statement. |
Connection | Sets a database connection. |
Transaction | Sets a transaction. |
method
Signature | Description |
Add(string,int) | Sets a value for the parameter. |
Add(string,long) | Sets a value for the parameter. |
Add(string,real) | Sets a value for the parameter. |
Add(string,string) | Sets a value for the parameter. |
AddNull(string) | Sets a null value for the parameter. |
NonQuery() | Executes the SQL statement. |
Reader() | Executes the SQL statement. |
Release() | Releases unmanaged resources. |
Scalar() | Executes the SQL statement. |