ISphinxQLExecutor.ExecuteNonQuery Method

ISphinxQLExecutorExecuteNonQuery Method

Executes a non-query command.

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

Syntax

int ExecuteNonQuery(
	string command,
	Object parameters = null
)

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

Parameters

command: Type: SystemString
The command to execute.
parameters (Optional): Type: SystemObject
Optional parameters for the command.

Return Value

Type: 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.

Examples

Copy

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

ISphinxQLExecutorQueryT(String, Object)

ISphinxQLExecutorQueryT(String, QueryMetadata, Object)

IAdvancedOperationsCreateSphinxQLExecutor