Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
- Posts: 3
- Joined: Fri 26 Mar 2010 12:01
I've got an problem with sorting when I'm using this query:
Code: Select all
var LANDListQuery = from land in context.LAND
where land.COUNTRYNAME != null
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
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.