If nHibernate's IQueryOver can create a WHERE clause for a DB table or DB view, why wouldn't it be about to make a WHERE clause for a table returned by a DB stored procedure or named query? I all three cases the data being restricted is a two dimensional collection w/ named columns.
The SQL would look something like: SELECT * FROM (table/view/stored procedure/named query projection) WHERE <IQueryOver generated where clause> On Friday, January 27, 2017 at 3:24:58 PM UTC-5, Gunnar Liljas wrote: > > Hi! > > No, that's not possible, and I think the question should be "how would it > do that?". What would the resulting SQL look like? > > /G > > > > 2017-01-27 16:36 GMT+01:00 Jeff Buda <[email protected] <javascript:>>: > >> My product had a filter/search/sort feature that is written in terms of >> IQueryOver. It works well when we limit the contents of a mapped DB table >> or view. >> >> Now I need execute a stored procedure or named query and have the >> existing filter/search/sort code base limit the results of the stored >> procedure. The limiting has to be done in the SQL statement executed on the >> DB server. >> >> Does nhibernate support this feature? As far as I can tell it doesn't >> allow one to append a dynamic IQueryOver to a stored procedure. If that's >> true does anyone know why? >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at https://groups.google.com/group/nhusers. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
