C1MagentoCommand Class

C1MagentoCommand contains all the necessary information to fully specify a Magento command and execute it.

Inheritance

object

MarshalByRefObject

Component

DbCommand

C1CommandBase

C1CommandBase<C1MagentoCommand>

C1MagentoCommand

Implements

Namespace: C1.AdoNet.Magento

Assembly: C1.AdoNet.Magento.dll

Syntax

public sealed class C1MagentoCommand : C1CommandBase<C1MagentoCommand>, IComponent, IDbCommand, IDisposable, IAsyncDisposable, ICloneable

Public NotInheritable Class C1MagentoCommand
    Inherits C1CommandBase(Of C1MagentoCommand)
    Implements IComponent, IDbCommand, IDisposable, IAsyncDisposable, ICloneable

Constructors

Name	Description
C1MagentoCommand()	Create a C1MagentoCommand instance.
C1MagentoCommand(C1MagentoConnection)	Create a C1MagentoCommand instance with a connection.
C1MagentoCommand(C1MagentoConnection, string)	Create a C1MagentoCommand 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 C1MagentoCommand.
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 `selectStmt` directly in the Magento server.
GetFullDataMagento(SelectStatement, CancellationToken)	Get full data for Magento.
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.
IgnoreCaseEquals(string, string)
Prepare()	Creates a prepared (or compiled) version of the command on the data source.
SupportColumnExpression(SelectStatement)	To check whether or not `selectStmt` can be executed directly on the Magento server considering the selected column expressions.
SupportDelete(DeleteStatement)	To check whether or not `deleteStmt` can be executed directly on the Magento server.
SupportGroupBy(GroupbyClause)	To check whether or not `groupby` can be executed directly on the Magento server.
SupportInsert(InsertStatement)	To check or not if `insertStmt` can be executed directly on the Magento server.
SupportJoin(SelectStatement)	To check whether or not joinStatement can be executed directly on the Magento server.
SupportOrderBy(IList<OrderbyColumn>)	Checks whether the passed `orderby` can or cannot be executed on the server.
SupportUpdate(UpdateStatement)	To check whether or not updateStatement can be executed directly on the Magento server.
SupportWhere(IExpression)	To check whether or not `where` can be executed directly on the Magento server.
ValidateStatement(ISQLStatement)	Validate for all type of statement.