How do you do full text search (FTS) with Linq to ADO.NET entity framework?

Entity Framework supports only a subset of the sql functionality available (partly to remain compatible over a range of providers). However, even LINQ-to-SQL (which supports a lot more SQL-Server specific constructs, such as UDFs) doesn't support full-text AFAIK I believe you need to use a stored procedure / udf. The UDF approach is preferred, as the metadata layer is much stronger, and it is composable at the db server - however, Entity Framework doesn't (or didn't, last time I checked) like UDFs ;-p So you may have to use a stored procedure.

Entity Framework supports only a subset of the sql functionality available (partly to remain compatible over a range of providers). However, even LINQ-to-SQL (which supports a lot more SQL-Server specific constructs, such as UDFs) doesn't support full-text AFAIK. I believe you need to use a stored procedure / udf.

The UDF approach is preferred, as the metadata layer is much stronger, and it is composable at the db server - however, Entity Framework doesn't (or didn't, last time I checked) like UDFs ;-p So you may have to use a stored procedure.

In the context of the answer above, this might help too: weblogs.asp. Net/scottgu/archive/2007/08/27/… – Jan Wikholm Sep 28 '09 at 6:00.

I've seen code like this for EF4: var query = context. ExecuteStoreQuery( "SELECT * FROM People WHERE FREETEXT(*,{0})", searchText ).AsQueryable(); This may be simpler than creating a stored proc or UDP in some cases.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.