Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Feature Request: Smart Renaming for Stored Procedures
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
01423270
Message ID:
01424326
Views:
65
>Yes, and I have to change them individually. For example, if I'm in the BLG and I just ran through it to create the business objects for the 'Seminar' table and now I'm creating them for the 'Conference' table, the default stored procedure names will still be 'SeminarSelect,' 'SeminarInsert,' etc. I'll carefully change the first one to 'ConferenceSelect' but the rest don't rename themselves nicely the way the class names did on the previous step.
>
>I think this may have changed when I got 3.6, because I thought this actually worked before but I didn't spend enough time in 3.5 to know for sure.

If you put the token
<DbcObjectName>
back into the stored procedure names in the BLG, it automatically places the table from which you are generating stored procedures into the stored procedure name for you. Here are the default values:
<DbcObjectName>Select
<DbcObjectName>Insert
<DbcObjectName>Update
<DbcObjectName>Delete
<DbcObjectName>SelectByPK
So, for example, if you create stored procedures from a User table, the BLG will name the stored procedures:
UserSelect
UserInsert
UserUpdate
UserDelete
UserSelectByPK
You can change the suffix, or even add a prefix, and the BLG will remember your settings the next time around.

Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform