Perform MySql Fulltext Search using NHibernate

Question

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)

Answer 1

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