Is there an effective full-text search solution in Entity Framework 4 that is independent of stored procedures?

Question

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

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

I can not find anything like it. The closer I have Sql Server UDF, imported into the storage scheme in combination with the custom EdmFunction. But UDFs in the storage schema cannot return Entity types.

The bottom line is: how can I implement the full text of SQL Server in an efficient way that is independent of stored procedures?

Answer 1

The answer in current versions of EF is: no way. EF does an abstraction for most common database functions, but for more complex scripts, EF + SQL / Stored Procedures is one tool, not two tools.