Full Text Search on SQL Azure [duplicate]

问题:

This question already has an answer here:

• SQL Azure and Full-Text Catalogs, Indexes and Searching 4 answers

I have a database that I am migrating to SQL Azure. There are a couple of stored procedures in this database that rely on ContainsTable. From my understanding, SQL Azure does not support this. Because of this, I was hoping there would be a way to imitate this functionality in C# code.

Does anyone know how to either: a) Utilize ContainsTable in SQL Azure or b) Imitate it in C# code?

回答1:

Yes, you are right that Contains Table are not supported on SQL Azure as described here.

Based on your question a) is not possible however b) is possible using Lucene.NET.

IF you wish to use code to get full text search in SQL Azure you would need to use Lucene.net in a web or worker role to index your SQL Azure data to Windows Azure Blob storage and then access the indexed data to search. The process is described as below:

1. Configure your Windows Azure Blob Storage
2. Use Web or Worker Role to access you SQL Azure and then create the Index on Windows Azure Blob Storage
3. Use the Indexed data stored at Windows Azure Blob Storage

Here is an article to start your work: How to Use Lucene.NET with SQL Azure (en-US)