Full Text Search for Microsoft SQL Server with Entity Framework
PM> Install-Package Fissoft.EntityFramework.FtsExecute init code on start or static ctor.
DbInterceptors.Init();When search you can use the code following.
var text = FullTextSearchModelUtil.Contains("code");
db.Tables.Where(c=>c.Fullname.Contains(text)); var text = FullTextSearchModelUtil.FreeText("code ef");
db.Tables.Where(c=>c.Fullname.Contains(text)); var text = FullTextSearchModelUtil.ContainsAll("code ef");
db.Tables.Where(c=>c.Name.Contains(text)); //c.Name could be any string property of model var text = FullTextSearchModelUtil.FreeTextAll("code ef");
db.Tables.Where(c=>c.Name.Contains(text)); //c.Name could be any string property of model var text = FullTextSearchModelUtil.Contains("a b",true);
var query = 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 wordsMulti field query
var query = db.TestModel
.Where(c => (c.Name+c.Text).Contains(text))
.ToList();will generate the sql
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);http://www.entityframework.info/Home/FullTextSearch
In .NET core 2.1 you can use offical freetext method to search.
Install the package Microsoft.EntityFrameworkCore.SqlServer.
using Microsoft.EntityFrameworkCore;
var result = db.TestModel.Where(c => EF.Functions.FreeText(c.Text, "search"));