CRUD

[Guest]

Hi.

Is there a way to generate the CRUD stored procedures for a table using the
Visual Studio 2005? I tried to do it in a new database project, but I can't
find a way to do it. Can VS 2005 generate them?

Thanks.
J

 

[RobinS]

Hi.

Is there a way to generate the CRUD stored procedures for a table using
the
Visual Studio 2005? I tried to do it in a new database project, but I
can't
find a way to do it. Can VS 2005 generate them?

Thanks.
J

Right-click on the StoredProcedure folder under the database connection in
Server Explorer and select Add New Stored Procedure from the context menu,
or select the database connection and click Data/Addnew/StoredProcedure
from the main menu.

Robin S.

 

[Guest]

Robin,

Thanks for your reply. I guess I should state my question more clearly.

What I wanted to find out is whether or not the Visual Studio 2005 can
actually
create the entire CRUD stored procedures and not just the skeleton of stored
procedure. I am talking about the actual stored procedure code for create,
retrieve, update, and delete.

If I do what you wrote, it only gives me a skeleton and not the actual SQL
code
to create, retrieve, update or delete a row.

There are some tools that can generate the entire stored procedures
for CRUD and you don't have to write a line of code.

Thanks.
J

 

[RobinS]

No, it doesn't. But check out this article. It tells how to build a stored
procedure generator.

http://www.code-magazine.com/Article.aspx?quickid=0509041

Robin S.
----------------------------------