Pretty trivial: Session.QueryOver<T>.Where(t=>t.Timestamp > startDate && t.TimeStamp < endDate)
On Saturday, August 1, 2015 at 6:40:05 AM UTC-4, Suhas Chatekar wrote: > > What is the actual query? > > Thanks > Suhas > > On Friday, 31 July 2015 20:55:18 UTC+1, Shatl wrote: >> >> Hello guys, >> I'm doing paging on query and trying to cache total count of rows. >> >> code looks like this >> >> var totalCount = qry.ToRowCountQuery().Cacheable().CacheMode(CacheMode. >> Normal).FutureValue<int>(); >> var pageData = qry.Skip((page - 1)*pageSize).Take(pageSize).Future< >> TEntity>(); >> >> >> I have 2nd level cache configured and expecting that query to get total >> count of rows will be cached. This works if total count query is not a >> FutureValue, but if it is declared as future, I always see 2 sql queries in >> a batch. >> >> Is it a bug? >> >> >> -- 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.
