>Hi everybody,
>
>I have the following EF query
>
>
> _countriesShort = _countriesAdapter.GetAll().OrderByDescending(x => x.Preferred).ThenBy(b => b.SortOrder).
> Select(c=> new CountriesShort { CountryId = c.CountryId, Descrip = c.Descrip, Iso2Code = c.Iso2Code } ).ToList();
>
>I am watching this code executing in SQL Profiler. I expect this query to pull just 3 columns after somehow selecting rows in the correct order (it's tricky, actually - in SQL Server I would use row_number() function for this instead).
>
>However, I see that query just translates into select all columns from the Countries table and I see no order by statement at all in this query.
>
>Can you explain this, please?
>
>Thanks in advance.
OrderBy() is a System.Linq extension - i.e it operates on the IEnumerable returned by your .....GetAll() - it will not be part of the SQL query