Description
Massimiliano Alberti created an issue — 23rd October 2012, 10:12:55:
There isn't any support for named queries calling from QueryOver (or from LINQ).
The scenario: I wanted to build a complex query in SQL that couldn't be built on NHibernate (let's say a query with a WHERE that references a PARTITION BY, to make an example) and that was parameterized. Being parameterized I couldn't use a View, so I decided to use a Table Function. Then I added a Named Query to call the TF. The query returned a list of fields equal to the one a SELECT * FROM MyTable would have returned.
There isn't any way to reference the TF from the QueryOver or the LINQ syntax (or at least I wasn't able to find it, and writing on nhusers no one was able to help me)
Massimiliano Alberti added a comment — 23rd October 2012, 10:14:22:
With "reference" I mean being able to add a Where clause, or a Join clause. I don't want to simply get the "plain" result set returned by the TF (that I could do without the QueryOver syntax)