Creating Entities from MySql Database causes all strings to be GUID

Posts   
 
    
njbelf
User
Posts: 70
Joined: 07-Jun-2017
# Posted on: 08-Sep-2017 16:38:16   

Hi, We are trying to generate LLBL code using MySQL as the underlying database. As part of this the Type converter for GUIDs needs to be in place so the generated code works properly as there is no GUID type in MySQL.

However, when creating entities after sync-ing from the MySQL database, the entity creator causes all strings no matter what length to be emitted as .NET guid.

I feel this is a bug possibly in the GUID TypeConverter. It should only cause the entity type of a 32 byte VARCHAR to be converted to a .Net GUID.

We are using v5.2.3 with a build date of 24-Aug-2017.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39590
Joined: 17-Aug-2003
# Posted on: 08-Sep-2017 23:24:34   

Did you add a type conversion for the type converter to the project and explicitly specify a varchar(32) filter with it?

Also, I assume you're using devart's connector and not the Mysql SA ado.net provider (as that one isn't supported and gives back different type tables)?

Frans Bouma | Lead developer LLBLGen Pro
njbelf
User
Posts: 70
Joined: 07-Jun-2017
# Posted on: 11-Sep-2017 16:52:17   

We had a typeConverter but it did not have the restrictions on it for VarChar 32. Since those parameters where ghosted, I didn't think they could be selected. Thanks for the note.

Yes, we are using devart..

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39590
Joined: 17-Aug-2003
# Posted on: 11-Sep-2017 20:24:04   

yes they're not enabled by default, only when you check the checkbox in front of it. Did that fix your problem? simple_smile

Frans Bouma | Lead developer LLBLGen Pro