Re: [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