C# Class DevExpress.DataAccess.BigQuery.BigQueryCommand

A SQL statement to be executed against a BigQuery data source.

Inheritance: System.Data.Common.DbCommand, ICloneable

Private Properties

Свойство	Type	Description
ICloneable	object

Méthode	Description
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.

Méthode	Description
CreateDbParameter ( ) : DbParameter
ExecuteDbDataReader ( CommandBehavior behavior ) : System.Data.Common.DbDataReader
ExecuteDbDataReaderAsync ( CommandBehavior behavior, CancellationToken cancellationToken ) : Task

Méthode	Description
ICloneable ( ) : object

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

public BigQueryCommand ( ) : System
Résultat	System

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

public BigQueryCommand ( BigQueryCommand command ) : System
command	BigQueryCommand	A BigQueryCommand object to clone.
Résultat	System

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.
Résultat	System

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.
Résultat	System

Cancels the execution of the current BigQueryCommand.

public Cancel ( ) : void
Résultat	void

protected CreateDbParameter ( ) : DbParameter
Résultat	System.Data.Common.DbParameter

protected ExecuteDbDataReader ( CommandBehavior behavior ) : System.Data.Common.DbDataReader
behavior	CommandBehavior
Résultat	System.Data.Common.DbDataReader

protected ExecuteDbDataReaderAsync ( CommandBehavior behavior, CancellationToken cancellationToken ) : Task
behavior	CommandBehavior
cancellationToken	System.Threading.CancellationToken
Résultat	Task

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

public ExecuteNonQuery ( ) : int
Résultat	int

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.
Résultat	Task

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

public ExecuteScalar ( ) : object
Résultat	object

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.
Résultat	Task

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

public Prepare ( ) : void
Résultat	void