Generating CRUD stored procedures

Is there a free simple tool to generated standard CRUD (Create, Read, Update, Delete) Stored Procedures for a given MS SQL (2005) database? Just starting to code them by hand and it's a bit monotonous!
LVL 3
CaltorAsked:
Who is Participating?
 
momi_sabagCommented:
you can write one yourself
its pretty easy
you can get the metadata you need from
information_schema.columns
0
 
dportasCommented:
I use Apex SQL Code:
http://www.apexsql.com/sql_tools_code.asp

Also Codesmith:
http://www.codesmithtools.com

P.S. There is no such thing as free software.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
CaltorAuthor Commented:
momo_sabag: I am quite new to SQL and C# programming so that might be beyond me at the moment I'm afraid. I guess I will have to code them by hand for now.

dportas: This is for a volunteer project so I'm afraid I don't have money to buy those tools. What do you mean there is no such thing as free software? Do you mean that somebody somewhere pays for it even if it's not the user?
0
 
dportasCommented:
When you say "free" what you mean is free to licence. But the cost of a licence is only one part of the cost of software. Total cost of ownership also includes supporting, maintaining and using it. If your time is for free then I guess it's fair enough to say that the software is free too, I hadn't considered that.
0
 
CaltorAuthor Commented:
"Free" also depends from whose persepctive you are looking! ;)
0
 
chapmandewCommented:
Here is an article I wrote on how to script out a table definition using TSQL.  If you take the code an alter it around a bit, you could come up w/ something to generate your CRUD statements...worst case, you just figure out a little bit more about the idea momi gave you.

http://blogs.techrepublic.com.com/datacenter/?p=431
0
 
chapmandewCommented:
You received several good comments...can't see why you would close this.
0
 
CaltorAuthor Commented:
I'm not trying to be awkward I just can't see that anybody actually answered the question. I asked for a free simple tool. I got comments that recommended tools that weren't free. I got comments that recommended writing my own tool even though my stated level is beginner on this subject. My own comment actually gives links to free tools.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.