can you give an example of what you mean, please? On Monday, October 6, 2014 2:17:29 PM UTC+2, fknebels wrote: > > Could you use filters? > On Oct 6, 2014 8:04 AM, "Daniel Thaller" <[email protected] > <javascript:>> wrote: > >> I am creating queries from raw sql like this: () >> >> var query = "SELECT * from ORDERS o where o.Year in (:orderYear));"; >> >> var session = sessionFactory.OpenSession(); >> var result =session.CreateSQLQuery(query) >> .AddEntity(typeof(Order)) >> .SetInt32("orderYear",2012) >> .List<Order>(); >> >> The query shown above should be restricted further dynamically by the user. >> What i normally do is get an IQueryable and add my where-clauses. >> But how can i combine the query shown above with IQueryable WITHOUT getting >> the list of elements from the above query first? >> >> what i want (pseudocode): CurrentSession.Query<Order>().Where(x => >> query.Contains(x)).ToList() >> => so i want to execute both queries in the same statement, because if the >> first query yields many results i get in real performance-troubles if i have >> to retrieve the list of the first query beforehand. >> >> Is there a way to archive my goal? >> >> -- >> 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 http://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 http://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
