I have some table valued functions with parameters. I use them to do some
recursive query and some other queries based on "things" not supported by
nhibernate (for example OVER PARTITION BY). They return data in the same
format as a SELECT * FROM SomeTable where SomeTable is correctly mapped in
NHibernate.
I want to include this TVF (or the named query that I use for it) in a
QueryOver query, for example something like
var q = QueryOver.Of<SomeTable>(myTableFunction).Where(p => p.Id > 10);
but I don't know how to connect the Session.GetNamedQuery("myquery") that
returns an IQuery with the QueryOver, or how to create a
Projection.SqlFunction that encapsulates my TVF and use it... Or any other
way....
Thanks
--
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/-/-Wnpl85tzxQJ.
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.
