Efcore: SQL Server full-text search: FreeTextTable and ContainsTable table-valued functions

[divega]

In EF Core 2.1 we added support for FreeText predicates. Adding Contains support should be similar, but the next level of functionality is in the TVFs FreeTextTable amd ContainsTable.

[pmiddleton]

FreeTextTable looks interesting. @divega I can take a look at that part once I am done with standard TVFs.

[divega]

@pmiddleton sure thing! This is practically meant for you :smile:

[apavelm]

Hi @divega !
Please advice, is there any ETA on FreeTextTable ? Is it in the current roadmap?

thank you

[MikaelGRA]

I would be really interested in this feature as well. Especially ContainsTable. That would be very useful for many of our projects.

[zhangsquall]

Any word on ETA?

[ajcvickers]

@zhangsquall This issue is in the Backlog milestone. This means that it is not going to happen for the 3.0 release. We will re-assess the backlog following the 3.0 release and consider this item at that time. However, keep in mind that there are many other high priority features with which it will be competing for resources.

[lixaotec]

How to use containstable along with ef core 3?
Is there ant workaround?

[cyptus]

FREETEXTTABLE together with ORDER BY RANK would be very interesting, as FREETEXT does not give us much advantage, as the result is not sorted by rank.

[lixaotec]

Is there any workaround to use containstable with Entity and fromrawsql with order by, just like mentioned in this SO: https://stackoverflow.com/questions/58656891/order-by-not-selected-column?
thanks