Wrong SQL generated when using OrderBy and FirstOrDefault

   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 ?