Geek asks and answers

Is there a way to find out if a sql server column is full text indexed through EF?

I am creating a query generator based on EF and Linq.Expression. I was wondering if there is a way to get column information through something in EF.

I am looking for information about the full text index, which you can see in the property windows on SQl Server.

Can anyone help?

For information, here is a T-SQL query that retrieves this information for a PitMingTable table:

select sc.name, columnproperty(OBJECT_ID('PitMingTable'),sc.name,'IsFulltextIndexed')
from sysobjects so
inner join syscolumns sc on so.id = sc.id
where so.name like 'PitMingTable' and so.xtype ='u'

thank.

+3
source share
3 answers

, Framework Entity Framework, . , , . , Entity Framework , , .

, SQL, , , . : SQL Server DB , SQL Server.

+2

. EF , SQL EF (ExecuteStoreQuery).

+1

You can fulfill the request using your context. To get a list of full text indexes, use this:

SELECT * FROM sys.fulltext_indexes

Here is the description: sys.fulltext_indexes

If you do not want to use sql queries, I think you can add view sys.fulltext_indexesto your model and work with it using EF.

0
source

More articles:


All Articles