# C1.AdoNet.Salesforce.C1SalesforceCommand

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="C1_AdoNet_Salesforce_C1SalesforceCommand" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand" class="text-break">C1SalesforceCommand Class
</h1>
  <div class="markdown level0 summary"><p><a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.html">C1SalesforceCommand</a> contains all the necessary information to fully specify a Salesforce command and execute it.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <div class="inheritance">
    <h5>Inheritance</h5>
    <div class="level0"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></div>
    <div class="level1"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.marshalbyrefobject">MarshalByRefObject</a></div>
    <div class="level2"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.componentmodel.component">Component</a></div>
    <div class="level3"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.data.common.dbcommand">DbCommand</a></div>
    <div class="level4"><a class="xref" href="../C1.AdoNet.CSV/C1.DataConnector.AdoNet.C1CommandBase.html">C1CommandBase</a></div>
    <div class="level5"><a class="xref" href="C1.DataConnector.AdoNet.C1CommandBase-1.html">C1CommandBase</a>&lt;<a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.html">C1SalesforceCommand</a>&gt;</div>
    <div class="level6"><span class="xref">C1SalesforceCommand</span></div>
  </div>
  <div class="implements">
    <h5>Implements</h5>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.componentmodel.icomponent">IComponent</a></div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.data.idbcommand">IDbCommand</a></div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.idisposable">IDisposable</a></div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.iasyncdisposable">IAsyncDisposable</a></div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.icloneable">ICloneable</a></div>
  </div>
  <h6><strong>Namespace</strong>: <a class="xref" href="C1.AdoNet.Salesforce.html">C1.AdoNet.Salesforce</a></h6>
  <h6><strong>Assembly</strong>: C1.AdoNet.Salesforce.dll</h6>
  <h5 id="C1_AdoNet_Salesforce_C1SalesforceCommand_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public sealed class C1SalesforceCommand : C1CommandBase&lt;C1SalesforceCommand&gt;, IComponent, IDbCommand, IDisposable, IAsyncDisposable, ICloneable</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public NotInheritable Class C1SalesforceCommand
    Inherits C1CommandBase(Of C1SalesforceCommand)
    Implements IComponent, IDbCommand, IDisposable, IAsyncDisposable, ICloneable</code></pre>
  </div>
  <h3 id="constructors">Constructors
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand__ctor" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.#ctor">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.-ctor.html#C1_AdoNet_Salesforce_C1SalesforceCommand__ctor">C1SalesforceCommand()</a>
        </td>
        <td class="markdown level1 summary"><p>Create a <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.html">C1SalesforceCommand</a> instance.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand__ctor_C1_AdoNet_Salesforce_C1SalesforceConnection_" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.#ctor(C1.AdoNet.Salesforce.C1SalesforceConnection)">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.-ctor.html#C1_AdoNet_Salesforce_C1SalesforceCommand__ctor_C1_AdoNet_Salesforce_C1SalesforceConnection_">C1SalesforceCommand(C1SalesforceConnection)</a>
        </td>
        <td class="markdown level1 summary"><p>Create a <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.html">C1SalesforceCommand</a> instance with a connection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand__ctor_C1_AdoNet_Salesforce_C1SalesforceConnection_System_String_" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.#ctor(C1.AdoNet.Salesforce.C1SalesforceConnection,System.String)">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.-ctor.html#C1_AdoNet_Salesforce_C1SalesforceCommand__ctor_C1_AdoNet_Salesforce_C1SalesforceConnection_System_String_">C1SalesforceCommand(C1SalesforceConnection, string)</a>
        </td>
        <td class="markdown level1 summary"><p>Create a <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.html">C1SalesforceCommand</a> instance with a connection and a command text.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="properties">Properties
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_CanGetNextData" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.CanGetNextData">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.CanGetNextData.html#C1_AdoNet_Salesforce_C1SalesforceCommand_CanGetNextData">CanGetNextData</a>
        </td>
        <td class="markdown level1 summary"><p>To check whether or not more data can be retrieved from the source as the result of executing this <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.html">C1SalesforceCommand</a>.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_CommandTimeout" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.CommandTimeout">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.CommandTimeout.html#C1_AdoNet_Salesforce_C1SalesforceCommand_CommandTimeout">CommandTimeout</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the wait time before terminating the attempt to execute a command and generating an error.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_CommandType" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.CommandType">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.CommandType.html#C1_AdoNet_Salesforce_C1SalesforceCommand_CommandType">CommandType</a>
        </td>
        <td class="markdown level1 summary"><p>Indicates or specifies how the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.data.common.dbcommand.commandtext">CommandText</a> property is interpreted.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_DbConnection" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.DbConnection">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.DbConnection.html#C1_AdoNet_Salesforce_C1SalesforceCommand_DbConnection">DbConnection</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.data.common.dbconnection">DbConnection</a> used by this <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.data.common.dbcommand">DbCommand</a>.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_DesignTimeVisible" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.DesignTimeVisible">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.DesignTimeVisible.html#C1_AdoNet_Salesforce_C1SalesforceCommand_DesignTimeVisible">DesignTimeVisible</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a value indicating whether the command object should be visible in a customized interface control.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_UpdatedRowSource" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.UpdatedRowSource">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.UpdatedRowSource.html#C1_AdoNet_Salesforce_C1SalesforceCommand_UpdatedRowSource">UpdatedRowSource</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets how command results are applied to the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.data.datarow">DataRow</a> when used by the Update method of a <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.data.common.dbdataadapter">DbDataAdapter</a>.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="methods">Methods
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_ExecuteBatchCoreAsync_System_Collections_Generic_IList_C1_DataConnector_ISQLStatement__System_Threading_CancellationToken_" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.ExecuteBatchCoreAsync(System.Collections.Generic.IList{C1.DataConnector.ISQLStatement},System.Threading.CancellationToken)">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.ExecuteBatchCoreAsync.html#C1_AdoNet_Salesforce_C1SalesforceCommand_ExecuteBatchCoreAsync_System_Collections_Generic_IList_C1_DataConnector_ISQLStatement__System_Threading_CancellationToken_">ExecuteBatchCoreAsync(IList&lt;ISQLStatement&gt;, CancellationToken)</a>
        </td>
        <td class="markdown level1 summary"><p>Execute a list of nonquery in Batch.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_ExecuteNonQueryCoreAsync_C1_DataConnector_ISQLStatement_System_Threading_CancellationToken_C1_DataConnector_SourceTable_" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.ExecuteNonQueryCoreAsync(C1.DataConnector.ISQLStatement,System.Threading.CancellationToken,C1.DataConnector.SourceTable)">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.ExecuteNonQueryCoreAsync.html#C1_AdoNet_Salesforce_C1SalesforceCommand_ExecuteNonQueryCoreAsync_C1_DataConnector_ISQLStatement_System_Threading_CancellationToken_C1_DataConnector_SourceTable_">ExecuteNonQueryCoreAsync(ISQLStatement, CancellationToken, SourceTable)</a>
        </td>
        <td class="markdown level1 summary"><p>The core method provided to execute a non-query statement.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_ExecutePrimitiveSqlAsync_C1_DataConnector_SelectStatement_System_Threading_CancellationToken_System_Boolean_" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.ExecutePrimitiveSqlAsync(C1.DataConnector.SelectStatement,System.Threading.CancellationToken,System.Boolean)">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.ExecutePrimitiveSqlAsync.html#C1_AdoNet_Salesforce_C1SalesforceCommand_ExecutePrimitiveSqlAsync_C1_DataConnector_SelectStatement_System_Threading_CancellationToken_System_Boolean_">ExecutePrimitiveSqlAsync(SelectStatement, CancellationToken, bool)</a>
        </td>
        <td class="markdown level1 summary"><p>Execute <code class="paramref">select</code> directly in the Salesforce server.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_GetNextResultAsync_System_Threading_CancellationToken_" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.GetNextResultAsync(System.Threading.CancellationToken)">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.GetNextResultAsync.html#C1_AdoNet_Salesforce_C1SalesforceCommand_GetNextResultAsync_System_Threading_CancellationToken_">GetNextResultAsync(CancellationToken)</a>
        </td>
        <td class="markdown level1 summary"><p>Request to get more rows result considering the last executed command.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_GetRequiredColumnNames_System_String_System_Collections_Generic_IList_C1_DataConnector_AssignExpression__" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.GetRequiredColumnNames(System.String,System.Collections.Generic.IList{C1.DataConnector.AssignExpression})">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.GetRequiredColumnNames.html#C1_AdoNet_Salesforce_C1SalesforceCommand_GetRequiredColumnNames_System_String_System_Collections_Generic_IList_C1_DataConnector_AssignExpression__">GetRequiredColumnNames(string, IList&lt;AssignExpression&gt;)</a>
        </td>
        <td class="markdown level1 summary"><p>Get the column names used to identify a specific row into update/delete query.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_Prepare" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.Prepare">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.Prepare.html#C1_AdoNet_Salesforce_C1SalesforceCommand_Prepare">Prepare()</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a prepared (or compiled) version of the command on the data source.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_SupportColumnExpression_C1_DataConnector_SelectStatement_" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.SupportColumnExpression(C1.DataConnector.SelectStatement)">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.SupportColumnExpression.html#C1_AdoNet_Salesforce_C1SalesforceCommand_SupportColumnExpression_C1_DataConnector_SelectStatement_">SupportColumnExpression(SelectStatement)</a>
        </td>
        <td class="markdown level1 summary"><p>To check whether or not <code class="paramref">selectStatement</code> can be executed directly on the
Salesforce server considering the selected column expressions.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_SupportDelete_C1_DataConnector_DeleteStatement_" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.SupportDelete(C1.DataConnector.DeleteStatement)">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.SupportDelete.html#C1_AdoNet_Salesforce_C1SalesforceCommand_SupportDelete_C1_DataConnector_DeleteStatement_">SupportDelete(DeleteStatement)</a>
        </td>
        <td class="markdown level1 summary"><p>To check whether or not <code class="paramref">deleteStatement</code> can be executed directly on the Salesforce server.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_SupportGroupBy_C1_DataConnector_GroupbyClause_" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.SupportGroupBy(C1.DataConnector.GroupbyClause)">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.SupportGroupBy.html#C1_AdoNet_Salesforce_C1SalesforceCommand_SupportGroupBy_C1_DataConnector_GroupbyClause_">SupportGroupBy(GroupbyClause)</a>
        </td>
        <td class="markdown level1 summary"><p>To check whether or not <code class="paramref">groupby</code> can be executed directly on the Salesforce server.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_SupportInsert_C1_DataConnector_InsertStatement_" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.SupportInsert(C1.DataConnector.InsertStatement)">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.SupportInsert.html#C1_AdoNet_Salesforce_C1SalesforceCommand_SupportInsert_C1_DataConnector_InsertStatement_">SupportInsert(InsertStatement)</a>
        </td>
        <td class="markdown level1 summary"><p>To check or not if <code class="paramref">insertStatement</code> can be executed directly on the Salesforce server.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_SupportJoin_C1_DataConnector_SelectStatement_" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.SupportJoin(C1.DataConnector.SelectStatement)">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.SupportJoin.html#C1_AdoNet_Salesforce_C1SalesforceCommand_SupportJoin_C1_DataConnector_SelectStatement_">SupportJoin(SelectStatement)</a>
        </td>
        <td class="markdown level1 summary"><p>To check whether or not joinStatement can be executed directly on the Salesforce server.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_SupportUpdate_C1_DataConnector_UpdateStatement_" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.SupportUpdate(C1.DataConnector.UpdateStatement)">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.SupportUpdate.html#C1_AdoNet_Salesforce_C1SalesforceCommand_SupportUpdate_C1_DataConnector_UpdateStatement_">SupportUpdate(UpdateStatement)</a>
        </td>
        <td class="markdown level1 summary"><p>To check whether or not <code class="paramref">updateStatement</code> can be executed directly on the Salesforce server.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_SupportWhere_C1_DataConnector_IExpression_" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.SupportWhere(C1.DataConnector.IExpression)">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.SupportWhere.html#C1_AdoNet_Salesforce_C1SalesforceCommand_SupportWhere_C1_DataConnector_IExpression_">SupportWhere(IExpression)</a>
        </td>
        <td class="markdown level1 summary"><p>To check whether or not <code class="paramref">where</code> can be executed directly on the Salesforce server.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Salesforce_C1SalesforceCommand_ValidateStatement_C1_DataConnector_ISQLStatement_" data-uid="C1.AdoNet.Salesforce.C1SalesforceCommand.ValidateStatement(C1.DataConnector.ISQLStatement)">
          <a class="xref" href="C1.AdoNet.Salesforce.C1SalesforceCommand.ValidateStatement.html#C1_AdoNet_Salesforce_C1SalesforceCommand_ValidateStatement_C1_DataConnector_ISQLStatement_">ValidateStatement(ISQLStatement)</a>
        </td>
        <td class="markdown level1 summary"><p>Validate for all type of statement.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>
