Delete or update All Entities?

Posts   
 
    
sdgrow
User
Posts: 11
Joined: 01-Nov-2009
# Posted on: 12-Nov-2009 15:39:37   

After adding dozens of tables to the Entities group I realized I didn't change the abbreviation from ID to Id. So I want to go back and re-add all my tables again so this rule is applied.

The problem I cannot figure out where in the designer I can force the tables to be re-added or mass updated again so all the fields get renamed.

So I figured, I would just delete all the tables and start over but that also seems to be a problems as LLBLGen only allows me to delete 1 table at a time.

Is there a quick way to re-add or refresh all the existing Entities or do I have to manually delete them 1 at a time.

Sam

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 12-Nov-2009 20:12:24   

You can set "SyncRenamedFieldElementsAfterRefresh" and "SyncMappedElementNamesAfterRefresh" to true in the project properties and refresh the catalog - this should force all mapped field names to then re-sync with the database.

If you do need to remove and re-add tables the it is one at a time - sorry about that.

Matt

sdgrow
User
Posts: 11
Joined: 01-Nov-2009
# Posted on: 12-Nov-2009 21:26:54   

When I set those two options to TRUE it ignores the EntityFieldNameStripPattern. So now all my fields are set back to include the Prefixes.

When I first add a new table to the Entity section everything works correctly. My problem is if I made a mistake with the EntityFieldNameStripPatterns or want to now include several Abbreviation changes, I cannot get the existing Entities to update the fields like they do when you first add them.

The fix is to delete the table and re-add it but that's a real pain since there is no way to mass delete the existing tables.

Any other ideas?

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 13-Nov-2009 10:56:37   

Is there a quick way to re-add or refresh all the existing Entities or do I have to manually delete them 1 at a time

New project.

btw, Which Designer version (release date) are you using?

sdgrow
User
Posts: 11
Joined: 01-Nov-2009
# Posted on: 13-Nov-2009 18:40:27   

Version 2.6 October 9, 2009.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 14-Nov-2009 05:40:09   

I agree with Walaa, create a new project should work simple_smile Another workaround you can consider: http://llblgen.com/TinyForum/Messages.aspx?ThreadID=3130

David Elizondo | LLBLGen Support Team