http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2012 : Wrong SQL generated when using OrderBy and FirstOrDefault Fri, 10 Apr 2026 22:17:18 -700 Tue, 18 Jun 2013 00:31:04 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4177 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=4177&PID=16448#16448 Author: kdev
Subject: 4177
Posted: 18-Jun-2013 at 12:31am

Ok, thanks kimj]]> Tue, 18 Jun 2013 00:31:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4177&PID=16448#16448 http://www.ideablade.com/forum/forum_posts.asp?TID=4177&PID=16447#16447 Author: kimj
Subject: 4177
Posted: 17-Jun-2013 at 1:59pm

This appears to be an EF bug. See http://entityframework.codeplex.com/workitem/196.]]> Mon, 17 Jun 2013 13:59:13 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4177&PID=16447#16447 http://www.ideablade.com/forum/forum_posts.asp?TID=4177&PID=16434#16434 Author: kdev
Subject: 4177
Posted: 14-Jun-2013 at 2:57am

Hi,


I have an issue with the generated SQL of a query using Orderby and FirstOrDefault.

Let's say we have those 2 queries :

var qry = from myentity in myquery.Where(d => d.Id == 348802)
           select myentity.mypropertynavigation.OrderByDescending(m => m.Debut).Where(m => m.Debut <= DateTime.Today).FirstOrDefault();

=> It will correctly apply the ORDER BY and select the TOP(1)

var qry = from myentity in myquery.Where(d => d.Id == 348802)
           select myentity.mypropertynavigation.OrderByDescending(m => m.Debut).FirstOrDefault(m => m.Debut <= DateTime.Today);

=> It will ONLY select the TOP(1), the SQL contains no ORDER BY at all.


Is this a DF bug ?

]]> Fri, 14 Jun 2013 02:57:23 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4177&PID=16434#16434