C# 클래스 Mono.Data.Sqlite.SqliteCommand

상속: System.Data.Common.DbCommand, ICloneable
파일 보기 프로젝트 열기: rubenv/tripod 1 사용 예제들

Private Properties

프로퍼티 타입 설명
BuildNextCommand SqliteStatement
ClearCommands void
ClearDataReader void
GetStatement SqliteStatement
InitializeForReader void
SqliteCommand System

공개 메소드들

메소드 설명
Cancel ( ) : void

Not implemented

Clone ( ) : object

Clones a command, including all its parameters

CreateParameter ( ) : SqliteParameter

Create a new parameter

ExecuteNonQuery ( ) : int

Execute the command and return the number of rows inserted/updated affected by it.

ExecuteReader ( ) : SqliteDataReader

Overrides the default behavior of DbDataReader to return a specialized SqliteDataReader class

ExecuteReader ( CommandBehavior behavior ) : SqliteDataReader

Overrides the default behavior to return a SqliteDataReader specialization class

ExecuteScalar ( ) : object

Execute the command and return the first column of the first row of the resultset (if present), or null if no resultset was returned.

LastInsertRowID ( ) : long
Prepare ( ) : void

Does nothing. Commands are prepared as they are executed the first time, and kept in prepared state afterwards.

SqliteCommand ( ) : System

Default constructor

SqliteCommand ( SqliteConnection connection ) : System

Initializes the command and associates it with the specified connection.

SqliteCommand ( string commandText ) : System

Initializes the command with the given command text

SqliteCommand ( string commandText, SqliteConnection connection ) : System

Initializes the command with the given SQL command text and attach the command to the specified connection.

SqliteCommand ( string commandText, SqliteConnection connection, SqliteTransaction transaction ) : System

Initializes a command with the given SQL, connection and transaction

보호된 메소드들

메소드 설명
CreateDbParameter ( ) : DbParameter

Forwards to the local CreateParameter() function

Dispose ( bool disposing ) : void

Disposes of the command and clears all member variables

ExecuteDbDataReader ( CommandBehavior behavior ) : System.Data.Common.DbDataReader

Creates a new SqliteDataReader to execute/iterate the array of Sqlite prepared statements

비공개 메소드들

메소드 설명
BuildNextCommand ( ) : SqliteStatement

Builds an array of prepared statements for each complete SQL statement in the command text

ClearCommands ( ) : void

Clears and destroys all statements currently prepared

ClearDataReader ( ) : void

Called by the SqliteDataReader when the data reader is closed.

GetStatement ( int index ) : SqliteStatement
InitializeForReader ( ) : void

This function ensures there are no active readers, that we have a valid connection, that the connection is open, that all statements are prepared and all parameters are assigned in preparation for allocating a data reader.

SqliteCommand ( SqliteCommand source ) : System

메소드 상세

Cancel() 공개 메소드

Not implemented
public Cancel ( ) : void
리턴 void

Clone() 공개 메소드

Clones a command, including all its parameters
public Clone ( ) : object
리턴 object

CreateDbParameter() 보호된 메소드

Forwards to the local CreateParameter() function
protected CreateDbParameter ( ) : DbParameter
리턴 System.Data.Common.DbParameter

CreateParameter() 공개 메소드

Create a new parameter
public CreateParameter ( ) : SqliteParameter
리턴 SqliteParameter

Dispose() 보호된 메소드

Disposes of the command and clears all member variables
protected Dispose ( bool disposing ) : void
disposing bool Whether or not the class is being explicitly or implicitly disposed
리턴 void

ExecuteDbDataReader() 보호된 메소드

Creates a new SqliteDataReader to execute/iterate the array of Sqlite prepared statements
protected ExecuteDbDataReader ( CommandBehavior behavior ) : System.Data.Common.DbDataReader
behavior CommandBehavior The behavior the data reader should adopt
리턴 System.Data.Common.DbDataReader

ExecuteNonQuery() 공개 메소드

Execute the command and return the number of rows inserted/updated affected by it.
public ExecuteNonQuery ( ) : int
리턴 int

ExecuteReader() 공개 메소드

Overrides the default behavior of DbDataReader to return a specialized SqliteDataReader class
public ExecuteReader ( ) : SqliteDataReader
리턴 SqliteDataReader

ExecuteReader() 공개 메소드

Overrides the default behavior to return a SqliteDataReader specialization class
public ExecuteReader ( CommandBehavior behavior ) : SqliteDataReader
behavior CommandBehavior The flags to be associated with the reader
리턴 SqliteDataReader

ExecuteScalar() 공개 메소드

Execute the command and return the first column of the first row of the resultset (if present), or null if no resultset was returned.
public ExecuteScalar ( ) : object
리턴 object

LastInsertRowID() 공개 메소드

public LastInsertRowID ( ) : long
리턴 long

Prepare() 공개 메소드

Does nothing. Commands are prepared as they are executed the first time, and kept in prepared state afterwards.
public Prepare ( ) : void
리턴 void

SqliteCommand() 공개 메소드

Default constructor
public SqliteCommand ( ) : System
리턴 System

SqliteCommand() 공개 메소드

Initializes the command and associates it with the specified connection.
public SqliteCommand ( SqliteConnection connection ) : System
connection SqliteConnection The connection to associate with the command
리턴 System

SqliteCommand() 공개 메소드

Initializes the command with the given command text
public SqliteCommand ( string commandText ) : System
commandText string The SQL command text
리턴 System

SqliteCommand() 공개 메소드

Initializes the command with the given SQL command text and attach the command to the specified connection.
public SqliteCommand ( string commandText, SqliteConnection connection ) : System
commandText string The SQL command text
connection SqliteConnection The connection to associate with the command
리턴 System

SqliteCommand() 공개 메소드

Initializes a command with the given SQL, connection and transaction
public SqliteCommand ( string commandText, SqliteConnection connection, SqliteTransaction transaction ) : System
commandText string The SQL command text
connection SqliteConnection The connection to associate with the command
transaction SqliteTransaction The transaction the command should be associated with
리턴 System