adding full text search to a SQL Express table

Question

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:

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?

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

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

How does C# MVC relate to your fulltext searching problem? What technology are you using to connect to your database? — Matthew
– Matthew, Commented Sep 26, 2013 at 13:29
I don't think SQL Express even supports full-text search. What version are you using? — Yuck
– Yuck, Commented Sep 26, 2013 at 13:30
really there is no support for sql express, hmm. @Matthew what technology as in connecting with connection strings in my web.config? and changing the connection strings whenever i am pushing to production. is that what you mean? sorry i am not sure what you mean technology as i mentioned everythingi am using in the question. thanks — NULL
– NULL, Commented Sep 26, 2013 at 13:32
You can make this change from the server after the table is created in management studio. — Botonomous
– Botonomous, Commented Sep 26, 2013 at 13:35
Get sql server express with advanced tools for full text searching microsoft.com/en-gb/download/details.aspx?id=1842 — BLoB
– BLoB, Commented Sep 26, 2013 at 13:42

Community · Accepted Answer · 2017-05-23 12:03:25Z

2

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

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. "

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 -------->

edited May 23, 2017 at 12:03

CommunityBot

11 silver badge

answered Sep 27, 2013 at 7:34

BLoB

9,7879 gold badges58 silver badges77 bronze badges

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

Collectives™ on Stack Overflow

adding full text search to a SQL Express table

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related