[]
        
(Showing Draft Content)

C1.AdoNet.QuickBooksOnline.C1QuickBooksOnlineCommand

C1QuickBooksOnlineCommand Class

C1QuickBooksOnlineCommand contains all the necessary information to fully specify a QuickBooksOnline command and execute it.

Namespace: C1.AdoNet.QuickBooksOnline
Assembly: C1.AdoNet.QuickBooksOnline.dll
Syntax
public sealed class C1QuickBooksOnlineCommand : C1CommandBase<C1QuickBooksOnlineCommand>, IComponent, IDbCommand, IDisposable, IAsyncDisposable, ICloneable

Constructors

Name Description
C1QuickBooksOnlineCommand()

Create a C1QuickBooksOnlineCommand instance.

C1QuickBooksOnlineCommand(C1QuickBooksOnlineConnection)

Create a C1QuickBooksOnlineCommand instance with a connection.

C1QuickBooksOnlineCommand(C1QuickBooksOnlineConnection, string)

Create a C1QuickBooksOnlineCommand instance with a connection and a command text.

Properties

Name Description
CanGetNextData

To check whether or not more data can be retrieved from the source as the result of executing this C1QuickBooksOnlineCommand.

CommandTimeout

Gets or sets the wait time before terminating the attempt to execute a command and generating an error.

CommandType

Indicates or specifies how the CommandText property is interpreted.

DbConnection

Gets or sets the DbConnection used by this DbCommand.

DesignTimeVisible

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

UpdatedRowSource

Gets or sets how command results are applied to the DataRow when used by the Update method of a DbDataAdapter.

Methods

Name Description
ExecuteBatchCoreAsync(IList<ISQLStatement>, CancellationToken)

Execute a list of nonquery in Batch.

ExecuteNonQueryCoreAsync(ISQLStatement, CancellationToken, SourceTable)

The core method provided to execute a non-query statement.

ExecutePrimitiveSqlAsync(SelectStatement, CancellationToken, bool)

Execute select directly in the QuickBooksOnline server.

GetNextResultAsync(CancellationToken)

Request to get more rows result considering the last executed command.

GetRequiredColumnNames(string, IList<AssignExpression>)

Get the column names used to identify a specific row into update/delete query.

Prepare()

Creates a prepared (or compiled) version of the command on the data source.

SupportColumnExpression(SelectStatement)

To check whether or not selectStatement can be executed directly on the QuickBooksOnline server considering the selected column expressions.

SupportDelete(DeleteStatement)

To check whether or not deleteStmt can be executed directly on the QuickBooksOnline server.

SupportGroupBy(GroupbyClause)

To check whether or not groupby can be executed directly on the QuickBooksOnline server.

SupportInsert(InsertStatement)

To check or not if insertStmt can be executed directly on the QuickBooksOnline server.

SupportJoin(SelectStatement)

To check whether or not joinStatement can be executed directly on the QuickBooksOnline server.

SupportLimit(SelectStatement)

To check whether or not limitStatement can be executed directly on the QuickBooksOnline server.

SupportOrderBy(IList<OrderbyColumn>)

To check whether or not orderby can be executed directly on the QuickBooksOnline server.

SupportUpdate(UpdateStatement)

To check whether or not updateStmt can be executed directly on the QuickBooksOnline server.

SupportWhere(IExpression)

To check whether or not where can be executed directly on the QuickBooksOnline server.

ValidateStatement(ISQLStatement)

Validate for all type of statement.