| IStatement Interface |
Represents a single SQL statement.
Namespace: SQLitePCL.pretty
Assembly: SQLitePCL.pretty (in SQLitePCL.pretty.dll) Version: 1.0.0.0 (1.0.0)
SyntaxThe IStatement type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | ClearBindings |
Resets this statements bindings to Null.
|
| Dispose | Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from IDisposable.) |
| MoveNext | Advances the enumerator to the next element of the collection. (Inherited from IEnumerator.) |
| Reset | Sets the enumerator to its initial position, which is before the first element in the collection. (Inherited from IEnumerator.) |
| Status |
Retrieve and reset counter values from a prepared statement.
|
Extension Methods| Name | Description | |
|---|---|---|
 | Bind |
Binds the position indexed values in values to the
corresponding bind parameters in This.
(Defined by Statement.) |
| BindPropertiesT |
Binds the statement bind variables by name to the corresponding properties on the object obj.
(Defined by Statement.) |
| Execute |
Executes the IStatement with provided bind parameter values.
(Defined by Statement.) |
| ExecuteWithPropertiesT |
Executes the IStatement with provided bind object.
(Defined by Statement.) |
| Query | Overloaded.
Queries the database using the provided IStatement.
(Defined by Statement.) |
| Query(Object) | Overloaded.
Queries the database using the provided IStatement and provided bind variables.
(Defined by Statement.) |
Properties| Name | Description | |
|---|---|---|
 | BindParameters |
An IReadOnlyOrderedDictionaryTKey, TValue of the statement's bind parameters
keyed by the parameter name. Note when accessing by index the first parameter
is zero-based indexed unlike in the native SQLite APIs that are one-based indexed.
|
| Columns |
An IReadOnlyListT of the columns in the statement's resultset.
|
| Current | Gets the element in the collection at the current position of the enumerator. (Inherited from IEnumeratorIReadOnlyListIResultSetValue.) |
| IsBusy | if the statement is busy, otherwise .
|
| IsReadOnly | if the statement is readonly, otherwise .
|
| SQL |
The text string used to prepare the statement.
|
See Also