CRUD

[=?Utf-8?B?dGhlamFja29mYWxs?=]

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

--
Be Cool!

[RobinS]

"thejackofa ll" <th**********@d iscussions.micr osoft.comwrote in message
news:4D******** *************** ***********@mic rosoft.com...

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

--
Be Cool!

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.

[=?Utf-8?B?dGhlamFja29mYWxs?=]

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

--
Be Cool!
"RobinS" wrote:

>
"thejackofa ll" <th**********@d iscussions.micr osoft.comwrote in message
news:4D******** *************** ***********@mic rosoft.com...

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

--
Be Cool!

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.

[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...uickid=0509041

Robin S.
----------------------------------
"thejackofa ll" <th**********@d iscussions.micr osoft.comwrote in message
news:37******** *************** ***********@mic rosoft.com...

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

--
Be Cool!
"RobinS" wrote:

>>
"thejackofal l" <th**********@d iscussions.micr osoft.comwrote in message
news:4D******* *************** ************@mi crosoft.com...

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

--
Be Cool!

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.