Devart Forums

Posted: **Fri 16 Apr 2010 14:28**

Hi!

I've got an problem with sorting when I'm using this query:

var LANDListQuery = from land in context.LAND
                                        orderby land.COUNTRYNAME
                                        where land.COUNTRYNAME != null
                                        select land;

When I use query generated by linq in db I get good list, with A and Ä in good way. In my application all national characters are below 'normal', do you know where could be the problem?

I'm using dotConnect for Oracle 5.60 Beta Professional Trial, any support would be appreciated

Posted: **Fri 16 Apr 2010 15:12**

LINQ to SQL is not responsible for the sorting, it simply translates orderby clause into database-specific ORDER BY.
If you have difference between the results of the query shown in DataContext.Log property
and values in your application, then the reason can be in materialization.
Send me (support * devart * com, subject "LINQ orderby") a small test project illustrating the issue.
Please include DB Script and some test data to reproduce the problem.

Devart Forums

Sorting Problem

Sorting Problem