Faced with a problem related to wrong result sorting after adding .OrderBy() extension method in code.
Assume we have following table named TEST_TABLE:
Code: Select all
TITLE
----------
col_1
Patric
11_alloy
Zambia
zulu
Querying the DB directly:
Code: Select all
SELECT * from TEST_TABLE ORDER BY TITLE ASC;
TITLE
----------
col_1
Patric
Zambia
zulu
11_alloy
Querying the DB from code:
Code: Select all
db.TestRecords.OrderBy(x => x.Title).ToList();
SELECT "Extent1".TITLE
FROM TEST_TABLE "Extent1"
ORDER BY "Extent1".TITLE ASC
TITLE
----------
11_alloy
Patric
Zambia
col_1
zulu
So I want to ask: are we doing something wrong or is it a bug in dotConnect for Oracle?
We are using dotConnect 9.2.222.0 in Direct Mode.