CRUD

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
thejackofall said:
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
Click to expand...

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.
 
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
 
Back
Top