Copy entity source name from designer

Posts   
 
    
jovball
User
Posts: 434
Joined: 23-Jan-2005
# Posted on: 09-Jan-2018 21:15:32   

My primary database these days is a legacy mainframe DB2 beast. Table and column names tend to be both terse and obtuse. An example (and easier than most we have) would be a table named PART_EMPL_HIST. We use the designer to rename that as ParticipantEmploymentHistory and we do the same for columns. This works great for coding.

Sometimes we are looking to run an ad-hoc query in an tool such as IBM Data Studio (Yuck, but it's the best that IBM has.) For that, I need the "real" table name. It would be helpful to grab it from the designer but I can't find any way to do it.

I'd like to have some way to copy the real name from the Catalog Explorer, perhaps from the context menu. It would make me really happy if I could generate SQL statements from that context menu, ala SSMS. Select would be enough but I'm sure I'd find a way use DML statements too.

Attachments
Filename File size Added on Approval
Catalog-Explorer-context-menu.png 9,790 09-Jan-2018 21:17.16 Approved
daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 10-Jan-2018 07:01:05   

You ca know the table name in the catalog explorer, Right?. Also, in the Project menu, you can generate a CREATE script.

So, what you want is a way to generate (in a file or in memory) a create statement for that table. Is that correct?

David Elizondo | LLBLGen Support Team
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 10-Jan-2018 10:27:49   

hmm also have you looked at linqpad to run queries against the generated code/entities for adhoc queries? that would solve the problem for you to obtain the real table name.

Frans Bouma | Lead developer LLBLGen Pro
jovball
User
Posts: 434
Joined: 23-Jan-2005
# Posted on: 10-Jan-2018 16:09:13   

I'm not looking for the table DDL. This is for ad-hoc query purposes so I'm looking for just the table name (right-click "Copy table name") or a full select script like SSMS does (right-click "Generate Select script to clipboard").

I know that the table name is in the catalog explorer. And it's easy to get to from the entity. simple_smile It's tedious and error-prone for me to look at the name there and type it into another window. Especially with our "wonderful" table names like "TCASE_ACT_XTRCT1" and "TITLE_XVI_PYT_HST." disappointed

LinqPad wouldn't solve the issue that I need to use some non .NET tools with DB2. Sometimes this is IBM DataStudio and other times it is a TN3270 session (green screen).

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 11-Jan-2018 18:26:47   

simple_smile That's indeed something that one might need. Going from entity to mapped table and do something with that is perhaps currently a bit cumbersome (lots of navigating) which should be easier and the results should be usable with e.g. the clipboard.

We'll think of something to make this easier, also the idea of generating SQL is something to think about, as well as going quick to the mapped target and do something with that, e.g. copy the name and perhaps other info as well.

Frans Bouma | Lead developer LLBLGen Pro
jovball
User
Posts: 434
Joined: 23-Jan-2005
# Posted on: 20-Sep-2018 23:37:36   

I know that you're wrapping up work on v5.5 now. Any chance of something like this making it into v5.6?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 21-Sep-2018 10:19:44   

jovball wrote:

I know that you're wrapping up work on v5.5 now. Any chance of something like this making it into v5.6?

Chances are high, it won't make it into 5.5 tho.

Frans Bouma | Lead developer LLBLGen Pro
jovball
User
Posts: 434
Joined: 23-Jan-2005
# Posted on: 26-Sep-2018 16:01:42   

I'm fine with that. I know I'm probably an edge case with this request.