SQL Server Code Generation
-
Hi, I need some feedback on some code generation software I'm in the process of re-developing for SQL Server (2005/2008). Its called SSCodeGen (for 2005/2008) and the new version (8.3) is now up at www.RaisinTech.com/SSCodeGen.exe, It will - Generate the 4 standard (A/I/U/D) stored procedures for a table (text/image field not currently handled) - Generate the execute statements for a stored procedure (slightly more complete than that generated from SS Man Studio) - Generate the sql for S/I/U/D statements for one or 2 tables on the database. Obviously it is free, and it doesn't require installation, you can just download and run. There is a version for SQL Server 7/2000 at http://users.quista.net/thealey/. Any comments appreciated
BillyTheKidney
-
Hi, I need some feedback on some code generation software I'm in the process of re-developing for SQL Server (2005/2008). Its called SSCodeGen (for 2005/2008) and the new version (8.3) is now up at www.RaisinTech.com/SSCodeGen.exe, It will - Generate the 4 standard (A/I/U/D) stored procedures for a table (text/image field not currently handled) - Generate the execute statements for a stored procedure (slightly more complete than that generated from SS Man Studio) - Generate the sql for S/I/U/D statements for one or 2 tables on the database. Obviously it is free, and it doesn't require installation, you can just download and run. There is a version for SQL Server 7/2000 at http://users.quista.net/thealey/. Any comments appreciated
BillyTheKidney
This is a good excercise and every developer should build such a tool, I am continually astonished to see some quite skilled dev hand coding crud procedures and methods. Try extending it to include the c#/VB stubs to call the stored proc. Also think about parameterised queries instead of procs, I am currently changing mine to do this because sql compact does not support procs X| . Then go on to create the model class for the table. Take into account where you have a view of the same data and add the additional fields into the model class.
Never underestimate the power of human stupidity RAH
-
This is a good excercise and every developer should build such a tool, I am continually astonished to see some quite skilled dev hand coding crud procedures and methods. Try extending it to include the c#/VB stubs to call the stored proc. Also think about parameterised queries instead of procs, I am currently changing mine to do this because sql compact does not support procs X| . Then go on to create the model class for the table. Take into account where you have a view of the same data and add the additional fields into the model class.
Never underestimate the power of human stupidity RAH
Thanks for the input, appreciated. The old SQL Server 7/2000 version generates the old VB/ASP code for calling a stored proc, though I haven't got round to changing it for the 2005/8 version as yet. I would be interested to see your code generation software.
BillyTheKidney