Click or drag to resize
ISphinxQLExecutor.QueryMulti Method
Executes the given SphinxQL multi-query and returns an instance of MultiQueryResult that can be used to retrieve the results for the queries.

Namespace: SphinxConnector.FluentApi
Assembly: SphinxConnector (in SphinxConnector.dll) Version: 3.12.6
Syntax
Copy
MultiQueryResult QueryMulti(
	string multiQuery,
	Object parameters = null
)

Parameters

multiQuery
Type: System.String
The multi-query to execute.
parameters (Optional)
Type: System.Object
The (optional) parameters for the query.

Return Value

Type: MultiQueryResult
An instance of MultiQueryResult that can be used to retrieve the results for the queries.
Exceptions
ExceptionCondition
ArgumentExceptionOccurs if multiQuery is empty.
ArgumentNullExceptionOccurs if multiQuery is null.
Examples
Suppose you have the following class representing a document in your index:
Copy
public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Description { get; set; }
    public decimal Price { get; set; }
    public int CategoryId { get; set; }
    public int VendorId { get; set; }
    public int Weight { get; set; }
}

You want to execute a full-text query over your products and retrieve some facets along with it by using Sphinx' FACET-clause that was introduced with Sphinx 2.2.3:
Copy
public class VendorFacet
{
    public int Count { get; set; }        
    public int VendorId { get; set; }
}

public class CategoryFacet
{
    public int Count { get; set; }
    public int CategoryId { get; set; }        
}

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

    var parameters = new { query = "a product" };

    using (var multiQueryResult = sphinxQLExecutor.QueryMulti(@"SELECT * FROM products WHERE MATCH(@query) 
                                                                FACET CategoryId 
                                                                FACET VendorId", parameters))
    {
        var productMatches = multiQueryResult.Read<Product>();

        var categoryFacets = multiQueryResult.Read<CategoryFacet>();

        var vendorFacets = multiQueryResult.Read<VendorFacet>();
    }        
}
Remarks
Note that the method automatically maps the 'count(*)' result column from the facet result to the 'Count' column of the respective objects.
See Also