How do I specify columns defined by the SQL "AS" keyword in the Entity Data Model?
SELECT LAST_NAME, FIRST_NAME, TRIM(FIRST_NAME || ' ' || LAST_NAME) AS FULL_NAME FROM TABLE1
Obviously FULL_NAME doesn't exist in the database, only in the query. I tried adding the column FULL_NAME to the table in the entity data model, but when I ran the query I got the message:
The data reader is incompatible with the speciified 'MODEL.TABLE1'. A member of the type, 'FULL_NAME', does nto have a corresponding column in the data reader with the same name.