Updated Version (9.5) creating invalid sql
Posted: Mon 06 Nov 2017 17:43
When projecting a linq query to to a DTO in a select clause like this:
This creates an alias in the generated Sql for ReallyLongProperty that is too long (32):
This results in a ORA-00972: identifier is too long.
This is just pseudocode, I can send concrete examples if necessary.
Thanks.
Code: Select all
var settings = from setting in context.AppSettings
select new AppSettingsDto {
ReallyLongPropertyNameInDtoClass = setting.ReallyLongProperty
};
var results = settings.ToArray() //This is where the error occursCode: Select all
SELECT "setting".REALLY_LONG_PROPERTY AS "ReallyLongPropertyNameInDtoClass"
FROM SCHEMA.APP_SETTINGS "setting"This is just pseudocode, I can send concrete examples if necessary.
Thanks.