ISphinxQLExecutorExecuteNonQueryAsync Method (String, CancellationToken, Object)

Asynchronously executes a non-query command.

Namespace: SphinxConnector.FluentApi
Assembly: SphinxConnector (in SphinxConnector.dll) Version: 5.4.1

Syntax

Task<int> ExecuteNonQueryAsync(
	string commandText,
	CancellationToken cancellationToken,
	Object parameters = null
)

Function ExecuteNonQueryAsync ( 
	commandText As String,
	cancellationToken As CancellationToken,
	Optional parameters As Object = Nothing
) As Task(Of Integer)

Parameters

commandText: Type: SystemString
The command to execute.
cancellationToken: Type: System.ThreadingCancellationToken
The token to monitor for cancellation requests.
parameters (Optional): Type: SystemObject
Optional parameters for the command.

Return Value

Type: TaskInt32
The number of rows affected by the statement.

Examples

Copy

using (IFulltextSession fulltextSession = fulltextStore.StartSession())
{
    ISphinxQLExecutor sphinxQLExecutor = fulltextSession.Advanced.CreateSphinxQLExecutor();

    CancellationTokenSource cts = new CancellationTokenSource();    

    int rowsAffected = await sphinxQLExecutor.ExecuteNonQueryAsync("DELETE FROM index WHERE id IN @ids", cts.Token, new { ids = new [] { 1, 2, 3 } });
}

Reference

ISphinxQLExecutor Interface

ExecuteNonQueryAsync Overload

SphinxConnector.FluentApi Namespace

ISphinxQLExecutorAddLanguageSpecificTextSet("LST106562A6_0?cpp=::|nu=.");ExecuteNonQueryAsync Method (String, CancellationToken, Object)

Parameters

Return Value

Reference

ISphinxQLExecutorExecuteNonQueryAsync Method (String, CancellationToken, Object)