Re: [nhusers] Re: Subquery in From Clause

There are certainly some problems we're still having with SQL 2005
paging.  Even with 2.0 beta 1 these problems occur and I've had to fall
back to the 2000 dialect for things to work properly.

 

I've reported NH-1350 (http://jira.nhibernate.org/browse/NH-1350) and I
think NH-1349 is linked.

Regards,

Sukhjinder Sidhu

 

From: [email protected]
[mailto:[email protected]] On Behalf
Of Will Shaver
Sent: 09 July 2008 16:58
To: the NHibernate development list
Subject: Re: [NHibernate-development] [nhusers] Re: Subquery in From
Clause

 

		SQL 2005 paging is broken.

 

Is it still? I fixed a couple of the JIRA issues around this... which
ones are still open?

 

It certainly is implemented in a strange way... but I'd argue that
whoever decided on the syntax for doing paging in SQL 2005 wasn't sane.
It's about the most complicated thing I've ever seen in SQL. Cross
Joins, Group By, Nested Case Statements... I can handle all of these
things in my head without any thought. SQL 2005 paging is messed up.

 

..

 

Building a better SQL assember would work, but may not be neccessary. If
the road were mine to plan here is what I'd recommend:

 

1) Improve the Linq implementation to where it works for 99% of users.

2) Move the Linq implementation into the core

3) Encourage all users to use the Linq implementation in documentation

4) Replace backend Linq -> SQL with whatever seems good at the time

5) Phase out HQL and Criteria as a way of getting to entities

6) Re-write Linq backend whenever we feel like it. Now that everyone is
on Linq it really doesn't matter to the user how the translation is
happening.

 

Lots of work. Step 2 is critical.

 -Will

 

 

 -Will

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08

_______________________________________________
Nhibernate-development mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/nhibernate-development