AutoInsert GeneratedSP option

Aug 22, 2007 at 11:25 AM
Edited Aug 22, 2007 at 11:27 AM

Nice work! :)

I looked at the Screencast "Hayden-DataAccessGuidancePackage.avi"
From that cast one could see the function to get the autogenerated SP to a script .SQL file

I have made my own hoby-tool to generate Entitie-classes, autogenerate SQL for sql-server and access DB providers.
In my tool I Autogenerate SP, optionally to the SQL Server directly (with in turn optional overwrite exisiting procedures).

I do this from my own custom templates giving control to defaultnames for standard operations like
Or usp_GetAllCustomers etc. (depending on bz-naming convention)
meaning that convention could be used so that one don't need to post modify the resulting sql-scripts.

Option to insert generated SP directly (checkbox....)
Aug 24, 2007 at 6:56 PM
This was actually a deliberate choice on our part. Essentially, everybody we talked to had a different preference on which sprocs to generate, what they should look like, etc. Knowing we couldn't please everybody, we chose to instead generate a starter set. Not automatically pushing to the database would, in theory, force folks to look at the generated sprocs and make sure they were what they wanted first.

In theory, anyway. No idea if it worked in practice or not.