Error with dotConnect when Sort desc

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
Posts: 28
Joined: Wed 12 Nov 2008 01:31

Error with dotConnect when Sort desc

Post by dqminh » Fri 23 Jan 2009 11:38

Hi, dotConnect version, db Oracle.

1. Create table
2. Generate code C# (Entity Developer for dotConnect)
3. Code:

Code: Select all

PartDataContext db = DCFactory.GetDataContext();
var d = db.Dealers.OrderByDescending(p => p.DealerCode).Skip(1).Take(10).AsEnumerable();

ORA-00904: "T2"."DEALER_CODEDESC": invalid identifier

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Devart.Data.Oracle.OracleException: ORA-00904: "T2"."DEALER_CODEDESC": invalid identifier

Maybe, in the generated sql query, you forget the space between field name and DESC :D

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

Post by AndreyR » Fri 23 Jan 2009 13:28

Thank you for the report, the bug has been fixed.
This fix will be available in the nearest build.

Post Reply