CODEWITHSUNDEEP
.netsql-serverentity-framework-4full-text-search
Andre Pena
Andre Pena

Reputation: 59336

Is there any effective solution for full-text search in Entity Framework 4 that doesn't rely on Stored Procedures?

I'm looking for a full-text search solution for Entity Framework 4. Stored Procedures cannot be considered because I have the need to compose queries. That is, given a search term I need to do something like this:

var query = from p in db.People.FullTextSearch('henry') where p.MaritalStatus == 2 select p;

I can't find anything like that. The closer I got is a Sql Server UDF imported in the store scheme combined with a custom EdmFunction. But UDFs in the store scheme cannot return Entity types.

The bottom line is: How can I implement SQL Server Full Text in an effective way that doesn't rely on Stored Procedures?

Upvotes: 4

Views: 394

Answers (1)

Ladislav Mrnka
Ladislav Mrnka

Reputation: 364249

The answer in current EF versions is: no way. EF makes abstraction on most common database features but for more advanced scenarios EF + SQL / Stored procedures are one tool not two tools.

Upvotes: 3

Related Questions