Search code examples
sql-serverentity-framework-corefreetextfreetexttable

Is there an EF.Functions.ContainsTable() equivalent?


There's an EF.Functions.Contains() and EF.Functions.FreeText(). But I can't find a ContainsTable() or FreeTextTable(). Is the only way to do those to use FromSqlInterpolated()?

And if so, is this the correct usage:

dbContext.AppUsers.FromSqlInterpolated($@"SELECT * FROM CONTAINSTABLE(AppUsers, *, {Query}) as t INNER JOIN AppUsers u on u.Id = t.[KEY]").ToListAsync();

Solution

  • per the comment by @bricelam above the answer is no. And if you'd like to get this added, please vote here.