SphinxQLDataReaderNextResult Method

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

Definition

Namespace: SphinxConnector.SphinxQL
Assembly: SphinxConnector (in SphinxConnector.dll) Version: 6.1.0
C#
public override bool NextResult()

Return Value

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

Implements

IDataReaderNextResult

Example

C#
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");

    connection.Open();

    using (SphinxQLDataReader dataReader = command.ExecuteReader())
    {
        while (dataReader.Read())
        {
            Console.WriteLine(dataReader.GetInt64("id"));
        }

        dataReader.NextResult();

        while (dataReader.Read())
        {
            Console.WriteLine(dataReader.GetInt64("id"));
        }
    }
}

Exceptions

See Also