This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
LightSpeed 5.0.3066.0; Oracle client: Oracle Data Access Components (ODAC) 11.2.0.3.0; Oracle server: Oracle 11g XE 11.2.0.2.0 Class table inheritance with more than one child entity produces failing SQL when .FirstOrDefault() LINQ query is invoked. For example, query generated in the attached project is:
which fails with an error ORA-00918: column ambiguously defined (points to the second line: BaseEntity.*) |
|
|
The error is being caused by our use of the default values in the statement where Oracle is expecting to see a column alias for these. Unfortunately because of the way we have implemented CTI historically this is not possible to fix so you will not be able to use CTI in this way when targeting Oracle. Sorry we are not able to do anything more to remedy this.
|
|