SqliteCommand SqliteCommand SqliteCommand Class

Definition

Represents a SQL statement to be executed against a SQLite database.

public class SqliteCommand : System.Data.Common.DbCommand
type SqliteCommand = class
    inherit DbCommand
Public Class SqliteCommand
Inherits DbCommand
Inheritance
SqliteCommandSqliteCommandSqliteCommand

Constructors

SqliteCommand() SqliteCommand() SqliteCommand()

Initializes a new instance of the SqliteCommand class.

SqliteCommand(String) SqliteCommand(String) SqliteCommand(String)

Initializes a new instance of the SqliteCommand class.

SqliteCommand(String, SqliteConnection) SqliteCommand(String, SqliteConnection) SqliteCommand(String, SqliteConnection)

Initializes a new instance of the SqliteCommand class.

SqliteCommand(String, SqliteConnection, SqliteTransaction) SqliteCommand(String, SqliteConnection, SqliteTransaction) SqliteCommand(String, SqliteConnection, SqliteTransaction)

Initializes a new instance of the SqliteCommand class.

Properties

CommandText CommandText CommandText

Gets or sets the SQL to execute against the database.

CommandTimeout CommandTimeout CommandTimeout

Gets or sets the number of seconds to wait before terminating the attempt to execute the command. Defaults to 30.

CommandType CommandType CommandType

Gets or sets a value indicating how CommandText is interpreted. Only Text is supported.

Connection Connection Connection

Gets or sets the connection used by the command.

DbConnection DbConnection DbConnection

Gets or sets the connection used by the command. Must be a SqliteConnection.

DbParameterCollection DbParameterCollection DbParameterCollection

Gets the collection of parameters used by the command.

DbTransaction DbTransaction DbTransaction

Gets or sets the transaction within which the command executes. Must be a SqliteTransaction.

DesignTimeVisible DesignTimeVisible DesignTimeVisible

Gets or sets a value indicating whether the command should be visible in an interface control.

Parameters Parameters Parameters

Gets the collection of parameters used by the command.

Transaction Transaction Transaction

Gets or sets the transaction within which the command executes.

UpdatedRowSource UpdatedRowSource UpdatedRowSource

Gets or sets a value indicating how the results are applied to the row being updated.

Methods

Cancel() Cancel() Cancel()

Attempts to cancel the execution of the command. Does nothing.

CreateDbParameter() CreateDbParameter() CreateDbParameter()

Creates a new parameter.

CreateParameter() CreateParameter() CreateParameter()

Creates a new parameter.

ExecuteDbDataReader(CommandBehavior) ExecuteDbDataReader(CommandBehavior) ExecuteDbDataReader(CommandBehavior)

Executes the CommandText against the database and returns a data reader.

ExecuteDbDataReaderAsync(CommandBehavior, CancellationToken) ExecuteDbDataReaderAsync(CommandBehavior, CancellationToken) ExecuteDbDataReaderAsync(CommandBehavior, CancellationToken)

Executes the CommandText asynchronously against the database and returns a data reader.

ExecuteNonQuery() ExecuteNonQuery() ExecuteNonQuery()

Executes the CommandText against the database.

ExecuteReader() ExecuteReader() ExecuteReader()

Executes the CommandText against the database and returns a data reader.

ExecuteReader(CommandBehavior) ExecuteReader(CommandBehavior) ExecuteReader(CommandBehavior)

Executes the CommandText against the database and returns a data reader.

ExecuteReaderAsync() ExecuteReaderAsync() ExecuteReaderAsync()

Executes the CommandText asynchronously against the database and returns a data reader.

ExecuteReaderAsync(CommandBehavior) ExecuteReaderAsync(CommandBehavior) ExecuteReaderAsync(CommandBehavior)

Executes the CommandText asynchronously against the database and returns a data reader.

ExecuteReaderAsync(CancellationToken) ExecuteReaderAsync(CancellationToken) ExecuteReaderAsync(CancellationToken)

Executes the CommandText asynchronously against the database and returns a data reader.

ExecuteReaderAsync(CommandBehavior, CancellationToken) ExecuteReaderAsync(CommandBehavior, CancellationToken) ExecuteReaderAsync(CommandBehavior, CancellationToken)

Executes the CommandText asynchronously against the database and returns a data reader.

ExecuteScalar() ExecuteScalar() ExecuteScalar()

Executes the CommandText against the database and returns the result.

Prepare() Prepare() Prepare()

Creates a prepared version of the command on the database. This has no effect.

Applies to