C# Класс DevExpress.DataAccess.BigQuery.BigQueryCommand

A SQL statement to be executed against a BigQuery data source.
Наследование: System.Data.Common.DbCommand, ICloneable
Показать файл Открыть проект Примеры использования класса

Private Properties

Свойство Тип Описание
ICloneable object

Открытые методы

Метод Описание
BigQueryCommand ( ) : System

Initializes a new instance of the BigQueryCommand class with default settings.

BigQueryCommand ( BigQueryCommand command ) : System

Initializes a new instance of the BigQueryCommand class with the specified prototype.

BigQueryCommand ( string commandText ) : System

Initializes a new instance of the BigQueryCommand class with the specified command text.

BigQueryCommand ( string commandText, BigQueryConnection connection ) : System

Initializes a new instance of the BigQueryCommand class with the specified command text and connection settings.

Cancel ( ) : void

Cancels the execution of the current BigQueryCommand.

ExecuteNonQuery ( ) : int

Executes a non-query SQL statement and returns the number of rows affected.

ExecuteNonQueryAsync ( CancellationToken cancellationToken ) : Task

Asynchronously executes a non-query SQL statement. The asynchronous result contains the number of rows affected.

ExecuteScalar ( ) : object

Executes a SQL statement and returns the first column of the first row of the resulting data.

ExecuteScalarAsync ( CancellationToken cancellationToken ) : Task

Asynchronously executes a SQL statement. The asynchronous result contains the first column of the first row of the resulting data.

Prepare ( ) : void

Creates a prepared (or compiled) version of the command on the data source. This implementation always throws NotSupportedException.

Защищенные методы

Метод Описание
CreateDbParameter ( ) : DbParameter
ExecuteDbDataReader ( CommandBehavior behavior ) : System.Data.Common.DbDataReader
ExecuteDbDataReaderAsync ( CommandBehavior behavior, CancellationToken cancellationToken ) : Task

Приватные методы

Метод Описание
ICloneable ( ) : object

Описание методов

BigQueryCommand() публичный Метод

Initializes a new instance of the BigQueryCommand class with default settings.
public BigQueryCommand ( ) : System
Результат System

BigQueryCommand() публичный Метод

Initializes a new instance of the BigQueryCommand class with the specified prototype.
public BigQueryCommand ( BigQueryCommand command ) : System
command BigQueryCommand A BigQueryCommand object to clone.
Результат System

BigQueryCommand() публичный Метод

Initializes a new instance of the BigQueryCommand class with the specified command text.
public BigQueryCommand ( string commandText ) : System
commandText string A System.String values specifying the text of a SQL statement.
Результат System

BigQueryCommand() публичный Метод

Initializes a new instance of the BigQueryCommand class with the specified command text and connection settings.
public BigQueryCommand ( string commandText, BigQueryConnection connection ) : System
commandText string A System.String values specifying the text of a SQL statement.
connection BigQueryConnection A BigQueryConnection object.
Результат System

Cancel() публичный Метод

Cancels the execution of the current BigQueryCommand.
public Cancel ( ) : void
Результат void

CreateDbParameter() защищенный Метод

protected CreateDbParameter ( ) : DbParameter
Результат System.Data.Common.DbParameter

ExecuteDbDataReader() защищенный Метод

protected ExecuteDbDataReader ( CommandBehavior behavior ) : System.Data.Common.DbDataReader
behavior CommandBehavior
Результат System.Data.Common.DbDataReader

ExecuteDbDataReaderAsync() защищенный Метод

protected ExecuteDbDataReaderAsync ( CommandBehavior behavior, CancellationToken cancellationToken ) : Task
behavior CommandBehavior
cancellationToken System.Threading.CancellationToken
Результат Task

ExecuteNonQuery() публичный Метод

Executes a non-query SQL statement and returns the number of rows affected.
public ExecuteNonQuery ( ) : int
Результат int

ExecuteNonQueryAsync() публичный Метод

Asynchronously executes a non-query SQL statement. The asynchronous result contains the number of rows affected.
public ExecuteNonQueryAsync ( CancellationToken cancellationToken ) : Task
cancellationToken System.Threading.CancellationToken A cancellation token that can be used to cancel command execution.
Результат Task

ExecuteScalar() публичный Метод

Executes a SQL statement and returns the first column of the first row of the resulting data.
public ExecuteScalar ( ) : object
Результат object

ExecuteScalarAsync() публичный Метод

Asynchronously executes a SQL statement. The asynchronous result contains the first column of the first row of the resulting data.
public ExecuteScalarAsync ( CancellationToken cancellationToken ) : Task
cancellationToken System.Threading.CancellationToken A cancellation token that can be used to cancel command execution.
Результат Task

Prepare() публичный Метод

Creates a prepared (or compiled) version of the command on the data source. This implementation always throws NotSupportedException.
public Prepare ( ) : void
Результат void