NH Filter Fixed
0 views
Skip to first unread message
YJingLee
Nov 30, 2009, 4:16:37 AM11/30/09
to nhusers
Hi
I have read http://ayende.com/Blog/archive/2009/05/04/nhibernate-filters.aspx
post
the last picture that the filter generate sql is
" where '2009-04-16T10:42:59.00' >=comments0_.PostedAt and
comments0_.PostId=1"
Would you please edit NHibernate source to let NHibernate Filter
generate sql is
"where comments0_.PostId=1 and '2009-04-16T10:42:59.00'
>=comments0_.PostedAt"
in other words,the filter condition should be at last for greater
efficiency in sql2005
I have read http://ayende.com/Blog/archive/2009/05/04/nhibernate-filters.aspx
post
the last picture that the filter generate sql is
" where '2009-04-16T10:42:59.00' >=comments0_.PostedAt and
comments0_.PostId=1"
Would you please edit NHibernate source to let NHibernate Filter
generate sql is
"where comments0_.PostId=1 and '2009-04-16T10:42:59.00'
>=comments0_.PostedAt"
in other words,the filter condition should be at last for greater
efficiency in sql2005
Reply all
Reply to author
Forward
0 new messages