SphinxQLDataReaderNextResultAsync(CancellationToken) Method

Asynchronously advances the reader to the next result when reading the results of multiple queries.

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

Syntax

public override Task<bool> NextResultAsync(
	CancellationToken cancellationToken
)

Public Overrides Function NextResultAsync ( 
	cancellationToken As CancellationToken
) As Task(Of Boolean)

Parameters

cancellationToken CancellationToken: The token to monitor for cancellation requests.

Return Value

TaskBoolean
true if there are more result sets; otherwise false.
A task representing the asynchronous operation.

Exceptions

Exception	Condition
SphinxQLException

Example


             using (SphinxQLConnection connection = new SphinxQLConnection())
             {
                 SphinxQLCommand command = new SphinxQLCommand(connection);
                 command.CommandText = @"SELECT * from sakila WHERE MATCH(@match1);
                                         SELECT * from sakila WHERE MATCH(@match2)";
            
                 command.Parameters.Add("@match1", "room");
                 command.Parameters.Add("@match2", "amazing");
            
                 await connection.OpenAsync();
            
                 using (SphinxQLDataReader dataReader = await command.ExecuteReaderAsync())
                 {
                     while (await dataReader.ReadAsync())
                     {
                         Console.WriteLine(dataReader.GetInt64("id"));
                     }
            
                     await dataReader.NextResultAsync();
            
                     while (await dataReader.ReadAsync())
                     {
                         Console.WriteLine(dataReader.GetInt64("id"));
                     }
                 }
             }

Reference

SphinxQLDataReader Class

NextResultAsync Overload

SphinxConnector.SphinxQL Namespace