NuGet Install

PM>Install-Package Fissoft.EntityFramework.Fts

Demo

DbInterceptors.Init();

vartext=FullTextSearchModelUtil.Contains("code");db.Tables.Where(c=>c.Fullname.Contains(text));

vartext=FullTextSearchModelUtil.FreeText("code ef");db.Tables.Where(c=>c.Fullname.Contains(text));

vartext=FullTextSearchModelUtil.ContainsAll("code ef");    db.Tables.Where(c=>c.Name.Contains(text));//c.Name could be any string property of model

vartext=FullTextSearchModelUtil.FreeTextAll("code ef");db.Tables.Where(c=>c.Name.Contains(text));//c.Name could be any string property of model

vartext=FullTextSearchModelUtil.Contains("a b",true);varquery=db.TestModel.Where(c=>c.Name.Contains(text)).ToList();// Should return results that contain BOTH words. For the second param = false, should return records with either of the words

varquery=db.TestModel.Where(c=>(c.Name+c.Text).Contains(text)).ToList();

SELECT     [Extent1].[Id]AS [Id],     [Extent1].[Text]AS [Text],     [Extent1].[Name]AS [Name]FROM [dbo].[TestModels]AS [Extent1]WHERE CONTAINS(([Extent1].[Name] , [Extent1].[Text]),@p__linq__0);

Reference:

About .NET Core

usingMicrosoft.EntityFrameworkCore;varresult=db.TestModel.Where(c=>EF.Functions.FreeText(c.Text,"search"));