向SQL Express表添加全文搜索

I am developing in C# MVC Visual studio using sql express. Running my application on localhost, then i push final app to production which runs sql server. I would like to know how do I add full-text indexing to my existing table:

我正在使用sql express在c# MVC Visual studio中开发。在localhost上运行我的应用程序，然后我将最终的应用程序推向运行sql server的产品。我想知道如何在现有表中添加全文索引:

CREATE FULLTEXT INDEX ON dbo.People
(  
    Title,  
    Authors,
    Description  
)

So this query above where do i run it on visual studio as I am using sql express?

上面这个查询，我在visual studio上运行它，当我使用sql express时?

How about migrations? Do I need to add anything to my model.cs class? And do I need to enable migrations add fulltext search?

迁移呢?我需要为我的模型添加任何东西吗?cs的课吗?我是否需要启用迁移来添加全文搜索?

I could do this easily in php/mysql, but i am learning c# mvc so I am not sure what is required.

在php/mysql中，我可以很容易地做到这一点，但是我正在学习c# mvc，所以我不确定需要什么。

1 个解决方案

#1

Get sql server express with advanced tools for full text searching here a link

获取sql server express与高级工具在这里的全文搜索链接

If you expand the details section it states:

如果你扩大细节部分，它说:

" Microsoft SQL Server 2008 Express with Advanced Services is a free, easy-to-use version of the SQL Server Express data platform that includes an advanced graphical management tool and powerful features for reporting and advanced text-based searches. This edition provides powerful and reliable data management tools and rich features, data protection, and fast performance. It is ideal for small server applications and local data stores. "

“Microsoft SQL Server 2008 Express with Advanced Services是一个免费的、易于使用的SQL Server Express数据平台版本，其中包括一个高级的图形管理工具和强大的报告和基于文本的高级搜索功能。这个版本提供了强大而可靠的数据管理工具和丰富的特性、数据保护和快速的性能。它非常适合小型服务器应用程序和本地数据存储。”

EDIT: For some coding pointers have a read of this SO post and it's replies and also look at the links on the lower right of this page for 'similar' topics that may well be of interest. Over there -------->

编辑:对于一些编码指针，可以阅读一下SO post和它的回复，也可以看看这个页面右下方的链接，找到可能很有趣的“相似”主题。在那里- - - - - - - - >

#1