CODEWITHSUNDEEP
sql-serversolrlucene.netsolrnet
cian1991ferrari
cian1991ferrari

Reputation: 133

Creating Lucene Index On SQL Server Database

I am creating a custom web application in C# .NET and I have a completely custom built database schema. I need a search engine application which is comprehensive enough to search the entire database I am using. We have decided to use Lucene .NET and probably Solr on top. I would like some help though as I'm a beginner.

Firstly, how do I go about creating a Lucene .NET index using C# on a SQL Server 05 or 08 database?? If anyone can help me by explaining the steps involved, where to reference Lucene .NET files from etc. any help would be much appreciated.

Secondly, we are proposing using Solr on top to add additional functionality, but how do I go about doing this? What way does it run and what is required etc?? If using Solr on a Microsoft SQL Server box, must I use SolrNet over Solr?

Thanks in advance for all help received!

Upvotes: 0

Views: 2603

Answers (1)

Mauricio Scheffer
Mauricio Scheffer

Reputation: 99750

use Lucene .NET and probably Solr on top

Solr doesn't run on top of Lucene.NET. It's a stand-alone Java Search server built on top of Java (original) Lucene.

The simplest way to import data from a relational database into Solr is using the DataImportHandler.

SolrNet is a client, a .net library that communicates with Solr via HTTP. I briefly explained how the interactions work in this blog post.

Upvotes: 3

Related Questions