Relation naming convention

Posts   
 
    
shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 27-Apr-2010 14:15:54   

Hi

On a table, i have same relation repeated more than once. Of course, with different columna name. as far as DB is concerend, I have given proper relationship names (example: primarytableabbrevation_childtableabbreavtion_counter%) so is appears as table1_table2_1 like that.

But LLBLGEN does not read these relationnames from schema and hence it looks like the one in attached file

Is there anyway to read relation names from schemea for llblgen becoz changing these relationnames one by one in LLBLGEN is tedious job

Regards, Shekar

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 27-Apr-2010 21:37:59   

Unfortunalty not - relations in LLBLGen are automatically named based on the entity names (these don't have to be the same as the table names) rather than the name of the relationship in the database.

Matt

shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 28-Apr-2010 05:44:15   

MTrinder wrote:

Unfortunalty not - relations in LLBLGen are automatically named based on the entity names (these don't have to be the same as the table names) rather than the name of the relationship in the database.

Matt

Fine. but will be there be any issues as per attached screen shot, when i continue development ? - Shekar

Walaa avatar
Walaa
Support Team
Posts: 14994
Joined: 21-Aug-2005
# Posted on: 28-Apr-2010 11:49:28   

waw....26 relations between the same 2 tables, this must be a record. I think the maximum number of relation I've see between 2 tables were only4.

Anyway the only problem you will face if you don't rename the relations to something meaningful, is that most robably you won't be able to tell which is which.

I strongly recommend renaming them, even of it's a tedios task, right now, but it will prevent confusion and ambiguity.

But regarding the generatd code, it will compile fine and work fine if you don't rename them.

shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 28-Apr-2010 17:23:51   

Walaa wrote:

waw....26 relations between the same 2 tables, this must be a record. I think the maximum number of relation I've see between 2 tables were only4.

Anyway the only problem you will face if you don't rename the relations to something meaningful, is that most robably you won't be able to tell which is which.

I strongly recommend renaming them, even of it's a tedios task, right now, but it will prevent confusion and ambiguity.

But regarding the generatd code, it will compile fine and work fine if you don't rename them.

Thanks!