DevForce Community Forum : EntityQuery.AddOrderBy http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : EntityQuery.AddOrderBy Wed, 10 Jun 2026 08:41:58 -700 Thu, 05 Aug 2010 02:47:26 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2047 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ EntityQuery.AddOrderBy : Dear reader, using IdeaBlade... http://www.ideablade.com/forum/forum_posts.asp?TID=2047&PID=7994#7994 Author: hojo
Subject: 2047
Posted: 05-Aug-2010 at 2:47am

Dear reader,
 
using IdeaBlade DevForce Classic v3.7.1.0 we have encountered the following problem:
 
when using AddOrderBy() with an EntityQuery myquery using a nullable EntityColumn, there is a problem when using this query with pm.GetEntities<T>(myquery), _if_ the database actually contains null-values (for this column).
[I might add that myquery also uses "TOP", though I don't know whether that makes any difference.]
 
In this case the following error message appears:
 
uploads/886/EntityQuery_AddOrderBy.zip
 
If the table does not contain null-values (for this column) the query and ordering works fine.
 
If reading the entities into a list (without ordering) and using ApplySort afterwards on the list (for this column), ordering works fine.
 
[Unfortunately this seems to be no solution to us: using TOP the result set is just different, depending on whether sorting is used on SQL-level.]
 
Anyway, I would expect ordering to work already on SQL-level, whether the column is nullable or not, and whether there are null-values or not.
 
Can you reproduce this behaviour? Is there a solution to this?
 
Thanks for your reply
Jörg
 
]]> Thu, 05 Aug 2010 02:47:26 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2047&PID=7994#7994