SSDL Maxlength facet issue during scaffolding web api controller

Posts   
 
    
Posts: 8
Joined: 28-Oct-2016
# Posted on: 06-Dec-2016 16:35:08   

Hi,

I'm encountering 'error 0063: MaxLength facet isn't allowed for properties of type date' during the scaffolding phase of a web api project that utilizes the SSDL code generated by LLBLGEN.

Following is my environment: - Microsoft Visual Studio 2013, solution type is ASP.NET Web API (.NET Framework 4.5.2) - LLBLGEN 4.2 (target framework is EF6 when generating code) - Firebird 2.5 Database engine

Attached file contains the error and the corresponding SSDL generated by LLBLGEN. also attached is the table definition from Firebird.

Kindly help me fix the error.

Thanks & regards,

Arnold

Attachments
Filename File size Added on Approval
input_file_for_investigation.rar 62,840 06-Dec-2016 16:35.26 Approved
Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 07-Dec-2016 00:41:17   

Looks like a driver bug.

Could you please make sure you are using the latest release of v.4.2?

Posts: 8
Joined: 28-Oct-2016
# Posted on: 07-Dec-2016 02:22:58   

i'll try to update 4.2. we'll let you know if LLBLGEN's latest patch will fix this issue. thanks.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 07-Dec-2016 12:38:00   

Reproduced, bug in template

Frans Bouma | Lead developer LLBLGen Pro
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 07-Dec-2016 13:06:33   

Fixed. Please download the latest v4.2 released today, which contains a fix in the templates and also in the driver (for NUMERIC fields, which are generated as decimal(19,0) and which should have been decimal(18,0) for EF apparently).

Frans Bouma | Lead developer LLBLGen Pro
Posts: 8
Joined: 28-Oct-2016
# Posted on: 07-Dec-2016 14:01:15   

Hi Otis,

We'll try your new 4.2 release today. We used your previous 29Nov2016 update (as recommended by Walaa) but it did resolve the issue.

I'll keep you posted. Thanks

Posts: 8
Joined: 28-Oct-2016
# Posted on: 07-Dec-2016 14:13:24   

sorry for the typo error in my message above: should be read "29Nov2016 update (as recommended by Walaa) but it did not resolve the issue."

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 07-Dec-2016 15:59:22   

True, sorry for this confusion. We fixed it this morning. the designer date is the same, the template was updated. Could you try with the build available on the website now?

Frans Bouma | Lead developer LLBLGen Pro
Posts: 8
Joined: 28-Oct-2016
# Posted on: 08-Dec-2016 04:34:03   

Hi Otis,

Your 07Dec2016 4.2 release has worked perfectly. Offending "MaxLength=" on date type has been removed from SSDL.

This issue may be closed.

Thanks! Arnold