Full Text Search
Provide Full-Text Search capabilities similar to Lucene.Net-NHibernate
Simple support for FreeText functions on SQL Server is added in EF Core 2.1.
John Doe commented
I can't express how much I like this idea
ContainsTable and the other FTS functions would address this issue http://stackoverflow.com/questions/18746127/a-composable-full-text-search-with-a-code-first-model
Daniel Shryock commented
What is preventing entity framework from exposing the CONTAINS function as a function on SqlFunctions?
It seems like something like to this should be relatively trivial:
var results =
from x in context.Records
where SqlFunctions.Contains(x.Text,"full text query")
If anyone has any ideas on how to mock a function similar to the SqlFunctions.Contains example above, I'd be happy to hear it.
Without full text search EF will never be a complete database framework. There are a lot of application scenarios that the developer cannot go without having "full-text search" support.