C# Class DevExpress.DataAccess.BigQuery.BigQueryCommand

A SQL statement to be executed against a BigQuery data source.
Inheritance: System.Data.Common.DbCommand, ICloneable
Mostrar archivo Open project: DevExpress/BigQueryProvider Class Usage Examples

Private Properties

Property Type Description
ICloneable object

Public Methods

Method 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.

Protected Methods

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

Private Methods

Method Description
ICloneable ( ) : object

Method Details

BigQueryCommand() public method

Initializes a new instance of the BigQueryCommand class with default settings.
public BigQueryCommand ( ) : System
return System

BigQueryCommand() public method

Initializes a new instance of the BigQueryCommand class with the specified prototype.
public BigQueryCommand ( BigQueryCommand command ) : System
command BigQueryCommand A BigQueryCommand object to clone.
return System

BigQueryCommand() public method

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.
return System

BigQueryCommand() public method

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.
return System

Cancel() public method

Cancels the execution of the current BigQueryCommand.
public Cancel ( ) : void
return void

CreateDbParameter() protected method

protected CreateDbParameter ( ) : DbParameter
return System.Data.Common.DbParameter

ExecuteDbDataReader() protected method

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

ExecuteDbDataReaderAsync() protected method

protected ExecuteDbDataReaderAsync ( CommandBehavior behavior, CancellationToken cancellationToken ) : Task
behavior CommandBehavior
cancellationToken System.Threading.CancellationToken
return Task

ExecuteNonQuery() public method

Executes a non-query SQL statement and returns the number of rows affected.
public ExecuteNonQuery ( ) : int
return int

ExecuteNonQueryAsync() public method

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.
return Task

ExecuteScalar() public method

Executes a SQL statement and returns the first column of the first row of the resulting data.
public ExecuteScalar ( ) : object
return object

ExecuteScalarAsync() public method

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.
return Task

Prepare() public method

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