Sorting Problem

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 3
Joined: Fri 26 Mar 2010 12:01

Sorting Problem

Post by 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

Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by 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.

Post Reply