4.2 Designer does not fill in TypeConverter field

Posts   
 
    
njbelf
User
Posts: 70
Joined: 07-Jun-2017
# Posted on: 07-Jun-2017 16:31:18   

Hi All, We are stuck using 4.2 right now due to some changes that occurred in the 5x line so we cannot upgrade to that line just yet.

That said, I am using the 4.2 Designer to try and build a dual-homed entity model. We start with a working entity model using the Microsoft SQL backend and are trying to add a MySql database backed. In order to make this work, I need to use a TypeConverter from System.Boolean to System.Byte to tinyint. I have this TypeConverter set up, I have the options checked both at the designer and the project level.

When I auto-map, the TypeConverter gets applied but it does NOT apply the name of the TypeConverter to the TypeConverter to use column in the Field Mappings. Everything about the Target Element is filled out appropriately just that this last column is blank. Running a Validation confirms that it is blank.

Any ideas?

Attachments
Filename File size Added on Approval
llblTypeConverterError.JPG 135,305 07-Jun-2017 16:31.34 Approved
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 07-Jun-2017 16:53:15   

1) what is the build version of the llblgen pro designer, did you try the latest build? 2) what exactly blocks you from migrating to v5, if I may ask? (so we can address it simple_smile ) 3) if it's possible, please attach the source of the type converter and explain the types of the table field and entity field you want to assign the type converter on.

Frans Bouma | Lead developer LLBLGen Pro
njbelf
User
Posts: 70
Joined: 07-Jun-2017
# Posted on: 07-Jun-2017 17:46:48   

Otis wrote:

1) what is the build version of the llblgen pro designer, did you try the latest build?

2) what exactly blocks you from migrating to v5, if I may ask? (so we can address it simple_smile )

3) if it's possible, please attach the source of the type converter and explain the types of the table field and entity field you want to assign the type converter on.

1) We are using Version 4.2 Final released September 23rd, 2016 according to the About LLBLGen Pro

2) It has to do with how we generate DTOs and how v5 changed the DTO generation. I think it is more on our end to just take the time to figure out how to use the new DTO generation but we haven't had the time to do that yet.

3) I am using the provided SD.LLBLGen.Pro.TypeConverters.BooleanNumericConverter. I have attached a snip of the definition of this. I am trying to map from a System.Boolean in the Microsoft SQL database onto a tinyint in the MySQL database

Attachments
Filename File size Added on Approval
llblTypeConverterSpec.JPG 112,844 07-Jun-2017 17:46.56 Approved
Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 07-Jun-2017 19:17:06   

In the Type Conversion settings, could you please remove the DatabaseType additional filter, as it's set to TinyInt, while the db type is Unsigned TinyInt, this might be the cause.

njbelf
User
Posts: 70
Joined: 07-Jun-2017
# Posted on: 07-Jun-2017 20:31:22   

Walaa wrote:

In the Type Conversion settings, could you please remove the DatabaseType additional filter, as it's set to TinyInt, while the db type is Unsigned TinyInt, this might be the cause.

That in fact was it. Thank you very much.