http://www.primordialcode.com/blog/post/nhibernate-customize-linq-provider-user-defined-sql-functions
and http://darioquintana.com.ar/blogging/2009/03/13/registering-freetext-or-contains-functions-into-a-nhibernate-dialect/ 2011/8/30 mysterd429 <[email protected]> > Hi all, > > I've got an existing database that uses FREETEXTTABLE in a stored > procedure. I've been using the NHibernate LINQ provider (since we're > switching from LINQ to SQL to NHibernate), and I'd like to know if > there's a way to use FREETEXTTABLE using the LINQ provider. The > stored procedure takes a few parameters and selects the desired result > set (KEY and RANK columns). I have a class for these search result > rows. > > Currently, I can use the stored procedure using a named SQL query and > get back attached entities: > > IQuery query = Session.GetNamedQuery("DoSearch"); > query.SetParameter("searchTerm", searchTerm); > IList<SearchResult> results = query.List<SearchResult>(); > // results[0].ResultObject is the first underlying object. > > We have a few utility methods that use LINQ for some processing > (sorting, pagination, etc) that I'd like to reuse with this stored > procedure. > > Ideally, I'd like to do something like: > > var doSearch = Session.GetQueryableObjectFromNamedQuery("DoSearch"); > doSearch.SetParameter("serachTerm", searchTerm); > IQueryable<SearchResult> resultsQueryable = doSearch.AsQueryable(); > IList<SearchResult> results = > myUtilityInstance.SortAndPaginate(resultsQueryable); > > Any ideas? Thanks! > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
