Connecting Tech Pros Worldwide Forums | Help | Site Map

CRUD

=?Utf-8?B?dGhlamFja29mYWxs?=
Guest
 
Posts: n/a
#1: Feb 16 '07
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
Guest
 
Posts: n/a
#2: Feb 16 '07

re: CRUD



"thejackofall" <thejackofall@discussions.microsoft.comwrote in message
news:4DCA2DE2-3D52-4EDA-83FB-0444018552C3@microsoft.com...
Quote:
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?=
Guest
 
Posts: n/a
#3: Feb 20 '07

re: CRUD


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:
Quote:
>
"thejackofall" <thejackofall@discussions.microsoft.comwrote in message
news:4DCA2DE2-3D52-4EDA-83FB-0444018552C3@microsoft.com...
Quote:
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
Guest
 
Posts: n/a
#4: Feb 20 '07

re: CRUD


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.
----------------------------------
"thejackofall" <thejackofall@discussions.microsoft.comwrote in message
news:3719B4A1-7FA8-406B-B663-4645A619E590@microsoft.com...
Quote:
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:
>
Quote:
>>
>"thejackofall" <thejackofall@discussions.microsoft.comwrote in message
>news:4DCA2DE2-3D52-4EDA-83FB-0444018552C3@microsoft.com...
Quote:
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.
>>
>>
>>
>>

Closed Thread


Similar .NET Framework bytes