Query Index Count in Custom .NET Page

Question

I am building a custom .NET Page and I need to query the total count of items in each Sitecore index (backend is Solr). I have not been able to find any "hooks" or documentation of the Sitecore API to support my needs.

In older versions (I am building on 8.1), I was able to use the Sitecore.Search.SearchManager but it appears this is now obsolete. I am leaning towards hitting the Solr API directly.

Answer 1

Below link will help you get all the details about how to access indexes using LINQ

https://doc.sitecore.net/sitecore_experience_platform/developing/developing_with_sitecore/search_and_item_buckets/linq_to_sitecore

https://www.geekhive.com/buzz/post/2017/08/predicate-builder-advanced-search-queries/

You can also create your custom indexes so you can get count of total items for each index while building the indexes. Essentially when you access indexes all the calculations are done and you just fetch the total count.

Here's the example of creating custom indexes.

https://www.linkedin.com/pulse/implement-search-using-lucene-indexes-sitecore-cms-app-umar-desai/

Answer 2

The Sitecore ContentSearchManager is what you want for this kind of thing. It's definitely not obsolete.

First add a reference to the ContentSearch API by adding Sitecore.ContentSearch and Sitecore.ContentSearch.Linq libraries either as a direct reference or via the nuget feed.

You can query index state like this:

foreach (var index in ContentSearchManager.Indexes)
{
    var summary = index.Summary;
    var documents = summary.NumberOfDocuments;
}

Documentation for querying indexes is available here.