I have the following query:
SELECT Animals.name FROM Animals WHERE CONTAINS(*, 'feline AND black');
I am having trouble converting it to an Entity Framework Core query. I have a SQL Server with a catalog that has a few indexes.
I want to be able to use
CONTAINS to do a fulltext query on the tables. I cannot find the method in Entity Framework Core for fulltext search with
This is possible as of EF Core 2.1. You have to add a using statement for Microsoft.EntityFrameworkCore but after that you can use it as shown below
var results = db.Widgets .Where(x => EF.Functions.FreeText(x.ColumnName, "search text"));