ISphinxQLExecutorExecuteNonQuery Method

Executes a non-query command.

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

Syntax

int ExecuteNonQuery(
	string command,
	Object parameters = null
)

Function ExecuteNonQuery ( 
	command As String,
	Optional parameters As Object = Nothing
) As Integer

Parameters

command String: The command to execute.
parameters Object (Optional): Optional parameters for the command.

Return Value

Int32
The number of rows affected by the statement.

Exceptions

Exception	Condition
ArgumentException	Occurs if command is empty.
ArgumentNullException	Occurs if command is null.
FulltextException	Occurs when there is an error during the execution of the command.

Example


            using (IFulltextSession fulltextSession = fulltextStore.StartSession())
            {
                ISphinxQLExecutor sphinxQLExecutor = fulltextSession.Advanced.CreateSphinxQLExecutor();
                
                int rowsAffected = sphinxQLExecutor.ExecuteNonQuery("DELETE FROM index WHERE id IN @ids", new { ids = new [] { 1, 2, 3 } });
            }

Reference

ISphinxQLExecutor Interface

SphinxConnector.FluentApi Namespace

QueryT(String, Object)

QueryT(String, QueryMetadata, Object)

CreateSphinxQLExecutor