Search code examples
sql-serverstored-procedurescode-generation

Generating simple CRUD stored procs

I'm working on a project that is subject to certain corporate standards relating to SQL implementation. Specifically, that all SQL Server content be accessed only via stored proc. (No ORM or LINQ.)

80% or more of our needs can be handled through the basic CRUD (CREATE, READ, UPDATE, DELETE) type of procedure that should be fairly simple to generate. However, I've been unsuccessful so far in locating an existing tool that will generate these fairly simple "base" stored procedures.

So, can anyone point me to a tool that I can use to generate the bulk of my required procedures? Preferably one that allows some customization of the process, such as wrapping the statements in a basic BEGIN/END TRY construct.

Thanks.

Solution

  • SSMS Tools Pack from Mladen Prajdić sounds like it might fit the bill. You can customise the templates it uses.

    It's well worth trying anyway for its other handy features.