# How to implement elastic search in asp.net with sql server

**URL:** <https://discuss.elastic.co/t/how-to-implement-elastic-search-in-asp-net-with-sql-server/97392>\
**Category:** Elasticsearch\
**Created:** [August 17, 2017, 10:38am UTC](https://discuss.elastic.co/t/how-to-implement-elastic-search-in-asp-net-with-sql-server/97392 "2017-08-17T10:38:59Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nikunj113](https://avatars.discourse-cdn.com/v4/letter/n/eb9ed0/32.png) [@Nikunj113](https://discuss.elastic.co/u/Nikunj113)\
**Post date:** [August 17, 2017, 10:38am UTC](https://discuss.elastic.co/t/how-to-implement-elastic-search-in-asp-net-with-sql-server/97392/1 "2017-08-17T10:38:59Z")

</div>

i have created website which is contain large amount of data and i have used [asp.net](http://asp.net) with sql server to build the website , now i want to implement elastic search with sql server database .if anyone knows so please help me

Thank You..

---

<div class="post-metadata">

**Author:** ![xavierfacq](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/xavierfacq/32/8744_2.png) [@xavierfacq](https://discuss.elastic.co/u/xavierfacq)\
**Post date:** [August 17, 2017, 12:46pm UTC](https://discuss.elastic.co/t/how-to-implement-elastic-search-in-asp-net-with-sql-server/97392/2 "2017-08-17T12:46:58Z")

</div>

hi, maybe you should search somes documentations on Google...  
Basicly you'ill need : a connector, an ingest process and then run queries.

[https://www.elastic.co/guide/en/elasticsearch/client/net-api/current/index.html](https://www.elastic.co/guide/en/elasticsearch/client/net-api/current/index.html)

> **[How to Build a Search Page with Elasticsearch and .NET - Simple Talk](https://www.red-gate.com/simple-talk/dotnet/net-development/how-to-build-a-search-page-with-elasticsearch-and-net/)**
>
> Although SQL Server's Full-Text search is good for searching text that is within a database, there are better ways of implementing search if the text is less-well structured, or comes from a wide variety of sources or formats. Ryszard takes...

  
[http://joelabrahamsson.com/extending-aspnet-mvc-music-store-with-elasticsearch/](http://joelabrahamsson.com/extending-aspnet-mvc-music-store-with-elasticsearch/)

---

<div class="post-metadata">

**Author:** ![Nikunj113](https://avatars.discourse-cdn.com/v4/letter/n/eb9ed0/32.png) [@Nikunj113](https://discuss.elastic.co/u/Nikunj113)\
**Post date:** [August 19, 2017, 7:01am UTC](https://discuss.elastic.co/t/how-to-implement-elastic-search-in-asp-net-with-sql-server/97392/3 "2017-08-19T07:01:56Z")

</div>

Thank you for your response.  
now i want to know how to connect sql server and elastic search  
if anyone know than help me..

---

<div class="post-metadata">

**Author:** ![xavierfacq](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/xavierfacq/32/8744_2.png) [@xavierfacq](https://discuss.elastic.co/u/xavierfacq)\
**Post date:** [August 20, 2017, 7:08pm UTC](https://discuss.elastic.co/t/how-to-implement-elastic-search-in-asp-net-with-sql-server/97392/4 "2017-08-20T19:08:35Z")

</div>

> [@Nikunj113](#):
>
> now i want to know how to connect sql server and Elasticsearch

You need to write a program that queries all your lines in your SQL Server and write using Bulk into Elasticsearch.

---

<div class="post-metadata">

**Author:** ![Nikunj113](https://avatars.discourse-cdn.com/v4/letter/n/eb9ed0/32.png) [@Nikunj113](https://discuss.elastic.co/u/Nikunj113)\
**Post date:** [August 22, 2017, 10:13am UTC](https://discuss.elastic.co/t/how-to-implement-elastic-search-in-asp-net-with-sql-server/97392/5 "2017-08-22T10:13:20Z")

</div>

i have created one batch file to connect sql server and elastic search but i want to know how to pass stored procedure name in this batch file

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 19, 2017, 10:13am UTC](https://discuss.elastic.co/t/how-to-implement-elastic-search-in-asp-net-with-sql-server/97392/6 "2017-09-19T10:13:22Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
