spgen Forum Rss Feed

New Post: Use checkboxes in treeview

robrichard — Fri, 12 Jun 2009 20:09:21 GMT

It would be great to utilize checkboxes in the treeview so that a user can select multiple tables within a database and mass generate stored procedures instead of one at a time.

New Post: Confused

RogerMcCook — Fri, 12 Dec 2008 14:00:15 GMT

OK. I did not download the source code. I did download it and now I see that class. I will try it and hopefully I will understand what you did so I can use this knowledge. Thank you very much for the email. Good luck.

--
Roger McCook
Cell: 404-735-5126

-------------- Original message from YordanGeorgiev <notifications@codeplex.com>: --------------

From: YordanGeorgiev

Hi,

I really posted all the source code ... and there are no external dll's used ...

For the db stuff check the AbstractDatabase.cs file - this is the db wrapper used for all db related stuff ...

New Post: Confused

YordanGeorgiev — Thu, 11 Dec 2008 20:26:00 GMT

It would be easier to answer your question if you post some error messages ...

New Post: Confused

RogerMcCook — Thu, 11 Dec 2008 19:16:39 GMT

I'm a little confused. The application does a nice job of creating stored procedures and I played around with it and figured out that the xml file can be used to change the author name, etc. in the procedure comments, but the code mystifies me. There is a reference to an unknown assembly and chen I try to compile, if I take out that reference, then I get an error message that DbObject is not not valid because obviously there is a missing assembly. Nowhere is the connection object created. I assume that is in the missing assembly also. So, though it looks like it has promise, I must say I cannot use it at all except maybe to automate the creation of the most basic kind of stored procedure.

New Post: Web based version ....

YordanGeorgiev — Fri, 24 Oct 2008 19:24:20 GMT

Hi all !

I have started a web based version of a stored procedure generation ...

Basically it would have dummy interface with several buttons for the different type of generations ....

Have you seen something like this ?

Any ideas , suggestions would be appreciated ...

New Post: Good work

Darwood — Thu, 23 Oct 2008 13:34:36 GMT

Great little program. This is the best free Stored procedures generator that I have come across. I have posted a few issues in the issue tracker but they are mainly minor tweaks/niggles or suggestions for new features.

Keep up the good work.
Thanks a lot.
Darwood

NEW POST: Please change title to Stored Procedure Generator ...

DelphiAssistant — Sat, 31 May 2008 16:06:54 GMT

Thanks for attention, fixed.

fmorriso wrote:
Minor nit pick: please change the title from Stored Procdure Generator .... to Stored Procedure Generator ....

NEW POST: Some suggestions

pbolduc — Wed, 28 May 2008 01:06:55 GMT

I have worked on a similar type of project, NetTiers, and during my time supporting the community, I came across some issues that you may wish to address. I have also found some bugs that you may wish to fix.

Current version - sometimes as developers we are not allowed to change the db schema
Handle the SqlException thrown if the user enters incorrect database/database not started.
Add support for database names with spaces - currently throws SqlException on 'USE Foo Bar;'
Add support for table names and column names with spaces - currently generates invalid DDL, 'sp_Foo Bar_SelectAll' and invalid variable names, '@Foo bar nvarchar(MAX)'
Add support for prefixing the object names with the schema owner - not everyone can use dbo, ie in shared hosting
Make the '-- Create date:' comment optional - makes using a diff tool hard will lots of false positives
Make the 'IF EXISTS (...) DROP PROCEDURE' optional - sometimes we need to do ALTER PROCEDURE instead of DROP/CREATE.

Future versions - you may wish to consider
support loading single rows by unique constraints
support loading multiple rows by FK/indexes, ie sp_Orders_SelectAllByCustomerId

Phil

NEW POST: Please change title to Stored Procedure Generator ...

fmorriso — Tue, 27 May 2008 13:58:27 GMT

Minor nit pick: please change the title from Stored Procdure Generator .... to Stored Procedure Generator ....