I am trying to do a freetext query, but both of the following are
giving me SELECT N+1 according to NHProfiler ... am I missing
something obvious here?
Cheers
Jak
list = session.CreateSQLQuery("Select DISTINCT
CurriculumVitae.* from CurriculumVitae where Contains
(CurriculumVitae.Content, :searchString)")
.AddEntity("CurriculumVitae", typeof
(CurriculumVitae))
.SetString("searchString", "oracle")
.List<CurriculumVitae>();
list = session.CreateQuery("from Candidate c left
join fetch c.CurriculumVitae c1 where contains
(c1.Content, :keywords)")
.SetString("keywords", "\"manager\"")
.SetMaxResults(50)
.List<Candidate>();
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to nhusers@googlegroups.com
To unsubscribe from this group, send email to
nhusers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
