Roman
Roman

Reputation: 10403

Perform MySql Fulltext Search using NHibernate

Is it possible to execute a statement like this in NHibernate?

SELECT * FROM 
    mytable 
WHERE
    field2 = "word" 
OR  
    MATCH (field1) AGAINTS ('wordA' IN BOOLEAN MODE)

Upvotes: 1

Views: 434

Answers (1)

Mauricio Scheffer
Mauricio Scheffer

Reputation: 99750

Yes. Either register the function in the dialect or use Expression.Sql.

Upvotes: 2

Related Questions