ExecuteNonQueryAsync(CancellationToken cancellationToken)

This method returns an asynchronous version of ExecuteNonQuery(), which executes the command against its connection object and returns the number of rows affected with a CancellationToken.

Declaration

// C#
public override Task<int> int ExecuteNonQueryAsync(CancellationToken cancellationToken);

Return Value

A Task object representing the asynchronous operation immediately without blocking the calling thread for the whole duration of the query execution.

Implements

DbCommand

Exceptions

InvalidOperationException - The command cannot be executed.

Example

using Oracle.ManagedDataAccess.Client;
using System;
using System.Threading;
using System.Threading.Tasks;

namespace AsyncApp
{
  class AsyncDemo
  {
    static async Task Main()
    {
      string connection = "User Id=HR; Password=<PASSWORD>; Data Source=oracle;";
      OracleConnection oc = new OracleConnection(connection);
      await oc.OpenAsync(CancellationToken.None);
      Console.WriteLine("Connection opened successfully");

      OracleCommand cmd = oc.CreateCommand();
      cmd.CommandText = "insert into tab1 values(1)";
      Task task = cmd.ExecuteNonQueryAsync(CancellationToken.None);
      await task;
      Console.WriteLine("Query executed");
      oc.Close();
    }
  }
}

See Also: