Updated Version (9.5) creating invalid sql

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
utahking
Posts: 7
Joined: Thu 29 Jun 2017 15:20

Updated Version (9.5) creating invalid sql

Post by utahking » Mon 06 Nov 2017 17:43

When projecting a linq query to to a DTO in a select clause like this:

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 occurs
This creates an alias in the generated Sql for ReallyLongProperty that is too long (32):

Code: Select all

SELECT "setting".REALLY_LONG_PROPERTY AS "ReallyLongPropertyNameInDtoClass"
FROM SCHEMA.APP_SETTINGS "setting"
This results in a ORA-00972: identifier is too long.

This is just pseudocode, I can send concrete examples if necessary.

Thanks.

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: Updated Version (9.5) creating invalid sql

Post by Shalex » Tue 07 Nov 2017 18:18

Please upload a small test project with the corresponding DDL/DML script to ftp://ftp.devart.com (credentials: anonymous / yourEmail).

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: Updated Version (9.5) creating invalid sql

Post by Shalex » Fri 10 Nov 2017 15:32

The bug with generating SQL aliases in EF Core 2 is fixed. We will notify you when the new build of dotConnect for Oracle is available for download.

RoyLane
Posts: 1
Joined: Tue 21 Nov 2017 11:24

Re: Updated Version (9.5) creating invalid sql

Post by RoyLane » Thu 23 Nov 2017 11:58

Shalex wrote:The bug with generating SQL aliases in EF Core 2 is fixed. We will notify you when the new build of dotConnect for Oracle is available for download.
Is the new dl out yet Shalex?

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: Updated Version (9.5) creating invalid sql

Post by Shalex » Fri 24 Nov 2017 09:54

New build of dotConnect for Oracle 9.5.399 is available for download: viewtopic.php?f=1&t=36257.

Post Reply