Sorting Problem

Sorting Problem

Postby WitekB » Fri 16 Apr 2010 14:28


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

Code: Select all
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
Posts: 3
Joined: Fri 26 Mar 2010 12:01

Postby AndreyR » 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 Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Return to dotConnect for Oracle