Automatic Stored Procedure creation

[RFH Reseller: JohnnyW]

I used to have a bit of asp code which would create standard stored procs for tasks such as updating / inserting / deleating records from tables, and also generate ASP code for using the stored proc from you pages. I can't find the script anymore and was wondering if anyone had an ASP.net equivilent cos creating the stored procs is soooo boring and time consuming.

[RFH Reseller: Sol]

Hi Johnny,

There are a couple that I have used:

http://www.mygenerationsoftware.com
http://www.codesmithtools.com/

I have used the dOOdads architecture available as templates for use with the MyGeneration software which make data tier development a piece of cake, however the mileage varies depending on the application design.

[RFH Reseller: JohnnyW]

Thanks again Sol the mygeneration stuff look good, will have a futher look tommorow.

Hope all goes well tonight mate!

[RFH Customer: cswd]

Anyone tried nHibernate? I'm trying to look for shortcuts on a project i'm working on as I don't want to write the data tier at all really!