The long awaited beta of Sphinx 2.2.1 has just been released, and we're following suit with releasing version 3.8 of SphinxConnector.NET! It is available for download and via NuGet!
SphinxConnector.NET 3.8 contains a bulk of changes to support new features that have been introduced with Sphinx 2.2.1: the support for JSON attributes has been greatly expanded with the newest Sphinx release. New functions like IN, ALL, ANY, and INDEXOF have been added to JSON arrays. These functions are supported through their .NET equivalents via IEnumerable, IList, and SphinxConnector.NET’s In() extension method, e.g.:
using (IFulltextSession fulltextSession = fulltextStore.StartSession())
{
var results = fulltextSession.Query<Product>().
Select(p => new
{
Any = p.JsonTestEntity.Categories.Any(x => x > 2),
All = p.JsonTestEntity.Categories.All(x => x < 5),
IndexOf = p.JsonTestEntity.Categories.IndexOf(1),
In = p.JsonTestEntity.Categories.In(1, 2, 3)
}).
Where(x => x.In).
ToList();
}
Please note that the syntax for IN is a little different for JSON attributes than for MVAs: IN can only be used within SELECT and than be used as a filter in WHERE, instead of using it directly in the WHERE clause.
Other newly supported functions include LEAST, GREATEST, and LENGTH which work with both JSON arrays and MVAs via Min(), Max() and IEnumerable.Count(), ICollection.Count or Length:
using (IFulltextSession fulltextSession = fulltextStore.StartSession())
{
var results = fulltextSession.Query<JsonTestObject>().
Select(p => new
{
Min = p.JsonTestEntity.Categories.Min(),
Max = p.JsonTestEntity.Categories.Max(),
Count = p.JsonTestEntity.Categories.Count,
}).
ToList();
}
Note that LENGTH() has been available since the release of Sphinx 2.1.2.
Another new feature of Sphinx 2.2.1 is the HAVING clause, which is now also supported by the fluent API:
using (IFulltextSession fulltextSession = fulltextStore.StartSession())
{
var results = fulltextSession.Query<Product>().
Match("a product").
GroupBy(p => p.VendorId).
Select(p => new
{
p,
Count = Projection.Count()
}).
Having(p => p.Count > 1).
ToList();
}
The next feature has been supported by Sphinx for some time and can now be used from the fluent API: user variables with IN and NOT IN:
using (IFulltextSession fulltextSession = fulltextStore.StartSession())
{
var results = fulltextSession.Query<Product>().
Where(p => p.CategoryId.In("@my_user_var")).
ToList();
}
There are a few more new features not mentioned here, which you can find in the version history.
