JTWebMan posted on Tuesday, August 29, 2006

Why are we adding esp_ to all of our store procs? Is this a naming convention?

JT

JTWebMan replied on Tuesday, August 29, 2006

I changed them to this in our personal templetes:

Private Const FetchCommandFormat As String = "up_{0}_Get"
Private Const InsertCommandFormat As String = "up_{0}_Ins"
Private Const UpdateCommandFormat As String = "up_{0}_Upd"
Private Const DeleteCommandFormat As String = "up_{0}_Del"

As the shorter the better. Can we change this in the CodeSmith Templetes for C# and VB?

JT

rasupit replied on Wednesday, August 30, 2006

JTWebMan,

It would be impossible to make every body agrees on one naming convention so I suggest to leave as it is and let user change their personal copy when they don't like the naming convention.

However, customizing the template should be easy as every thing that can be customized are in the Constant Region of TemplateBase.cs

Ricky

JTWebMan replied on Thursday, August 31, 2006

Sounds good. I actually have started on a storeprocedure.cst file that uses templetebase.vb. When I complete it I will also add it to the templetebase.cs as well if you would like. I was going to do the formatting in the const section as well se that people can add there own comment blocks, etc...

JT