Join and Table-valued function

[Alexander Byndyu]

Hello,

How can I create query:

SELECT *

FROM Post po 

INNER JOIN GetPostBySearchQuery('search query') s ON s.Id = po.PostId

GetPostBySearchQuery - table-valued function, returns PostId list.

[Oskar Berggren]

ISession.CreateSQLQuery(), or use a named-query. See the NHibernate
reference documentation.

/Oskar


2013/1/24 Alexander Byndyu <alexande...@gmail.com>:

> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/nhusers/-/LJzQI01UoyQJ.
> To post to this group, send email to nhu...@googlegroups.com.
> To unsubscribe from this group, send email to
> nhusers+u...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en.

[Alexander Byndyu]

More correct formulation of the question:

Simplified code:

            IQueryOver<Post, Post> query =

                Session.QueryOver<Post>();

            if (string.IsNullOrEmpty(criterion.SearchQuery) == false)

            {

                // join results from GetPostBySearchQuery function

            }

If criterion.SearchQuery is not empty I should call Sphinx function.

SQL result should by like:

SELECT * FROM Post po

INNER JOIN GetPostBySearchQuery('search query') s ON s.Id = po.PostId

Best regards,

Byndyu Alexander

2013/1/24 Oskar Berggren <oskar.b...@gmail.com>