SubSonic3 StoredProcedures.tt & SQLServer.ttinclude

Question

In the template to get the stored procedures I see this line

if(spType=="PROCEDURE" &! sp.Name.StartsWith("sp_")){...

Why can't the sp's start with sp_?

Answer 1

Basically because that's what system stored procedures start with so you shouldn't use it as a naming convention for your SPs because then the first place SQL looks is in the Master database rather than in your database. This answer goes into detail as to why that's bad

It also stops SubSonic generating code for the system SPs.