This article shows how to create parent, child and grandchild documents in Elasticsearch using ElasticsearchCRUD. If creating documents which are related to each other, it is important that the documents are all saved to the same shard in Elasticsearch. The search performance is better, if a specific shard can be defined for the search. When […]

This article demonstrates how to export data from Elasticsearch to a CSV file using Web API. The data is retrieved from Elasticsearch using _search with scan and scroll. This API can retrieve data very fast without any sorting. The data is then exported to a CSV file using WebApiContrib.Formatting.Xlsx from Jordan Gray. The progress of […]

The article demonstrates how to do a live reindex in Elasticsearch using ElasticsearchCRUD. The reindex uses scan ans scroll the fetch the data and then updates to a new index using bulk inserts. The reindex has support for alias mapping which makes it possible to do a live index. Code: https://github.com/damienbod/LiveReindexInElasticsearch Other tutorials: Part 1: […]

This article demonstrates how to use Entity Framework with MS SQL Server as a primary database and Elasticsearch for the search/select functionality. The application combines the power and performance of Elasticsearch for search and fast selects and also Entity Framework for CUD transactions (Create, Update and Delete). Code: https://github.com/damienbod/WebSearchWithElasticsearchEntityFrameworkAsPrimary Other tutorials: Part 1: ElasticsearchCRUD introduction […]

This article demonstrates how to search for data in Elasticsearch using parent and child documents. The documents are all saved inside the same index and the child documents are saved on the same shard using the parent id as the routing. As in the previous ElasticsearchCRUD tutorials, an autocomplete in used to search for the […]

This article shows how to transfer data from a MS SQL Server 2014 to Elasticsearch. The MS SQL Server is accessed using Entity Framework (Code first from a database). Elasticsearch documents are created using ElasticsearchCRUD and inserted in bulk requests. The Entity Framework entities can be used directly in ElasticsearchCRUD. Either the whole entity including […]

This article demonstrates how to create Elasticsearch documents with NESTED objects using jQuery, jTable and moment.js in the MVC Razor View, and using MVC, ElasticsearchCRUD and Elasticsearch as the backend. The SearchController provides all CRUD Actions so you can experiment with the 1 to n entities, or the Elasticsearch nested documents. Not all Elasticsearch clients […]

This article demonstrates how to do a full text search using jQuery Autocomplete with an ASP.NET MVC application and an Elasticsearch search engine. CRUD operations are also implemented for Elasticsearch ( ElasticsearchCRUD ). To download and install Elasticsearch, use the instructions here. Code: https://github.com/damienbod/WebSearchWithElasticsearch Other tutorials: Part 1: ElasticsearchCRUD introduction Part 2: MVC application search […]

The article explains how to use the ElasticsearchCRUD NuGet package. ElasticsearchCRUD is designed so that you can do CRUD operations for any entity and insert, delete, update or select single documents from Elasticsearch. The package only includes basic search or query possibilities. Code: https://github.com/damienbod/ElasticsearchCRUD NuGet Package: https://www.nuget.org/packages/ElasticsearchCRUD/ Issues: https://github.com/damienbod/ElasticsearchCRUD/issues Tutorials: Part 1: ElasticsearchCRUD introduction Part […]

This article demonstrates how OData Functions can be used together with entities which have simple keys, composite keys, entity collections or used as plain simple global functions. Part 1 Getting started with Web API and OData V4 Part 1. Part 2 Web API and OData V4 Queries, Functions and Attribute Routing Part 2 Part 3 […]