Do, somebody, work on it ? 2009/4/7 Jesse Napier <[email protected]>
> +1 for that. I am always disappointed when a see that this type of query > creates a paged query when it is not needed. > > > ------------------------------ > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Fabio Maulo > *Sent:* Tuesday, April 07, 2009 8:24 AM > *To:* [email protected] > *Subject:* [nhibernate-development] Re: MsSQL dialect > > > > 2009/4/7 Ayende Rahien <[email protected]> > > I would say no, because that would produce drastically different behavior > when you start doing deeper pagin. > > > > IMO > > session.CreateQuery("from Category").SetMaxResults(25).List(); > > > > should be translated in > > SELECT TOP 25 {*} FROM Category > > > > without unneeded cursors. > > > > -- > Fabio Maulo > -- Fabio Maulo
