Have Geek Brain

Dumped data using CTE, how will it be with nHibernate?

I am using CTE to handle data paging currently, can query criteria handle CTE?

0


a source to share


1 answer


IIRC, nhibernate uses a CTE when paging in 2005+, so the query that is called calls the CTE using the paging query. This makes sense as there is no other way to do paging on sqlserver 2005/2008 unless you want to use temptables. (no, tricks etc don't work in all cases, o / r mappers should work with paging systems that always work)



+1


a source






More articles:


All Articles