Database relationships vs. custom relationships

Posts   
 
    
Posts: 35
Joined: 22-May-2006
# Posted on: 22-May-2007 17:58:50   

Hi,

In the previous releases of the databases on the project I work on all of the relationships have been enforced through triggers. To enable the use of relationships we have created custom relationships in LLBLGen. In the latest release, the database team have made the move to DRI. When I refreshed the schema it pulled in all of the relationships out of the database. Is there a way to determine which ones were created within LLBLGen and which ones came from SQL Server?

Thanks,

Nate

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 23-May-2007 09:37:50   

Where do you want to make this differentiation, in the Designer or in the code? Would you still use the custom relations now that you have database relations?

Please elaborate more on what you are trying to do.

Posts: 35
Joined: 22-May-2006
# Posted on: 24-May-2007 06:14:58   

What I am trying to do is determine which relationships are from the database in SQL Server and which ones are the custom ones that were created in the designer. We had created 20 or so custom relationships in the designer and now that our database finally has DRI relationships it imported 300+ relationships and I want to remove the custom ones as they are duplicate. I can't tell by looking at them or their properties which are the ones created in the designer and which are the ones that were brought in from the database schema.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 24-May-2007 06:36:59   

What if you delete the custom rels before refresh the catalog?

David Elizondo | LLBLGen Support Team
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 25-May-2007 10:20:53   

Indeed: remove the relations prior to refreshing will make the custom relations be replaced with the native ones. Though you don't have to remove the custom ones, for the code they're alike, so it won't make a difference. So to save yourself some time, just keep the custom ones if you can live with the small blue dots in the icons in the designer simple_smile

Frans Bouma | Lead developer LLBLGen Pro