How to use entity framework with elastic search

Question

I want to use on entity framework with elastic search.

I saw this article MVC APPLICATION WITH ENTITY FRAMEWORK AND ELASTICSEARCH.

But as I understood, I need 2 DB (ms sql+ elastic) and there they explain how to translate the data.

The ms sql I will save the data and I done the search on the elastic .

So all the data will be twice so it will be waste of storage...

Is there any direct way to do that?

thanks

Split your logic in two, store in your ES criterias and its respective IDs, then use those IDs to retrieve from SQL db. — Facundo La Rocca
– Facundo La Rocca, Commented Dec 5, 2016 at 2:01
Im working on a custom elastic provider, you can contribute github.com/exitxhu/Exitxhu.EntityFrameworkCore.Elastic — Hadi Bazmi
– Hadi Bazmi, Commented Jul 16 at 21:16

Benjamin · Accepted Answer · 2019-12-31 12:09:20Z

6

You can use entity framework with elastic search by utilising ElasticsearchCrud api.

This article clearly explains the steps to do so.

P.S: I rather not to copy/paste the steps here as it might look redundant.

edited Dec 31, 2019 at 12:09

answered Dec 5, 2016 at 3:09

Benjamin

3,8269 gold badges54 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vova Bilyachat · Accepted Answer · 2016-12-05 03:06:54Z

Yes you understood right you would need to use two different sources. There is no direct way to use elasticsearch with EF, you would need to write you custom logic to fit Database and Elasticsearch together.

If you ask why? Answer is that Database and Elasticsearch are different.

First of all Elastic is document database and you should save whole object while in database you can split items to multiple tables in ES "preferable" to save as a one document (Still in ES you can use nested objects but you will not be able to join).

Secondly search queries are totally different in SQl and Elastic. So sometimes only you would decide which source should be used to search. To search Elastic you can use NEST package but you would need to learn ES queries and indexing part since depends on analysis you will have defferent results.

Collectives™ on Stack Overflow

How to use entity framework with elastic search

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related