Full-text search and Entity Framework v1: is this possible?

Question

We work in EFv1, and I implement a search control with several filter options. I translated most of them. Where are the clauses and this is normal with EF.

But there is one specific filter that can make my application run very slowly: text search . The column in the database has the corresponding object property in my EF model, but I just can't put Contains there, this is not good for text search.

What do you think is useful to use in this case?

I heard about Lucene, I don't know if it integrates with EFv1.

thank

Answer 1

. :

• , .
• ( " " ). .
• ( " " ). ( ).

, , EntityCollection < > .

Answer 2

User Defined Function, , Entity Framework #. LINQ to SQL, EF . , : http://sqlblogcasts.com/blogs/simons/archive/2008/12/18/LINQ-to-SQL---Enabling-Fulltext-searching.aspx

Answer 3

, , . , ORM , , , .

EF , linq. EF v1 , , .

EF v1.

Answer 4

Lucene.NET EF, , , EF-.

Answer 5

EF4 - :

var query = context.ExecuteStoreQuery<Person>(
        "SELECT * FROM People WHERE FREETEXT(*,{0})", 
        searchText
    ).AsQueryable();

This may be easier than creating a stored proc or UDP in some cases. I know your question is about EF1, but someone passing by might find this helpful.