Error with dotConnect 5.0.20.0 when Sort desc
Posted: Fri 23 Jan 2009 11:38
Hi, dotConnect version 5.0.20.0, db Oracle.
1. Create table
2. Generate code C# (Entity Developer for dotConnect)
3. Code:
Exception:
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
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