Avoiding duplicate relationship-records in the model with refreshing the database model

Posts   
 
    
zweps79
User
Posts: 16
Joined: 28-Feb-2011
# Posted on: 28-Mar-2011 12:09:05   

Hello,

When I alter my database and want to let the model in LLBLGen (version 3.1, final) change along, I do this via 'Catalog Explorer->Refresh Relation Model Data from a Database...' and via 'Tools-> Refresh Code Generation Meta Data'.

The Model (Entities) do get updated, but already existent relationships of the Entity get duplicated with leading underscores added to the relationshipname (see the screenshot in the attachment).

How do I prevent this unwanted behavior?

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 28-Mar-2011 17:48:46   

Which version (release date) of the designer are you using?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39908
Joined: 17-Aug-2003
# Posted on: 29-Mar-2011 09:00:23   

In v3.1, we can't reproduce this behavior. Could you prepare a simple llblgenproj + database schema for us which reproduces this? Two tables with an FK relationship should be enough.

Frans Bouma | Lead developer LLBLGen Pro
zweps79
User
Posts: 16
Joined: 28-Feb-2011
# Posted on: 31-Mar-2011 14:31:40   

Hello,

I've tried to built a simular database, but the behavior doens't show.

Below some Log info while refreshing the Database Catalog:

Post-migration actions performed on entity model and other project elements Migration of relationships and unique constraints New relationship 'EntityEntityStatus.EntityType - EntityType.EntityEntityStatuses (m:1)' added between 'EntityEntityStatus' and 'EntityType'. New relationship 'EntityEntityStatus.EntityStatusType - EntityStatusType.EntityEntityStatuses (m:1)' added between 'EntityEntityStatus' and 'EntityStatusType'. New relationship 'ZorgAfspraak.Day - Day.ZorgAfspraaks (m:1)' added between 'ZorgAfspraak' and 'Day'. Duplicate names correction actions performed Navigator 'ZorgAfspraaks' on relationship 'ZorgAfspraak.Day - Day.ZorgAfspraaks (m:1)' has been renamed to 'ZorgAfspraaks' because its name was already in use by another element Navigator 'EntityStatusType' on relationship 'EntityEntityStatus.EntityStatusType - EntityStatusType.EntityEntityStatuses (m:1)' has been renamed to 'EntityStatusType' because its name was already in use by another element Navigator 'EntityType' on relationship 'EntityEntityStatus.EntityType - EntityType.EntityEntityStatuses (m:1)' has been renamed to 'EntityType' because its name was already in use by another element Navigator 'EntityEntityStatuses' on relationship 'EntityEntityStatus.EntityStatusType - EntityStatusType.EntityEntityStatuses (m:1)' has been renamed to 'EntityEntityStatuses' because its name was already in use by another element Navigator 'EntityEntityStatuses' on relationship 'EntityEntityStatus.EntityType_________ - EntityType.EntityEntityStatuses (m:1)' has been renamed to 'EntityEntityStatuses' because its name was already in use by another element Navigator 'Day' on relationship 'ZorgAfspraak.Day - Day.ZorgAfspraaks (m:1)' has been renamed to 'Day____' because its name was already in use by another element

If necessary, I can mail the LLBLgen project file, I rather don't place it on the forum keeping the company privacy rules in mind simple_smile

zweps79
User
Posts: 16
Joined: 28-Feb-2011
# Posted on: 31-Mar-2011 14:32:30   

By the way, the version of LLBLGen I have in use is Version 3.1 final, released on February 23rd, 2011.

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 31-Mar-2011 21:46:05   

You can either email the project file to suppport [at] llblgen.com, or open a helpdesk thread, as they are only visible to us and you. If you do this put a link to this thread in there so that we know where it is coming from.

Thanks

Matt

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39908
Joined: 17-Aug-2003
# Posted on: 01-Apr-2011 13:27:38   

Unless you provide a repro case we can't really reproduce it. I'll close the thread for now. If you have a repro case for us, please open a helpdesk thread and refer to this thread. Thanks.

Frans Bouma | Lead developer LLBLGen Pro