How to create a Stored Procedure programmatically using C#

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Abdulla Herzallah - 26 Sep 2004 11:28 GMT

Hi every one I have tried to search for any links, hints clues on how to
create a Stored Procedure programmatically using C# but came back with empty
handed :-(
I know it is definitly possible (i.e. what the Query Analyzer can do).
I will appreciate any help.
thanks

Abdulla

Reply to this Message

Cor Ligthert - 26 Sep 2004 11:45 GMT

Abdullah,

Just create the SQL strings and execute those using the executenonquerry

I hope this helps?

Cor

> Hi every one I have tried to search for any links, hints clues on how to
> create a Stored Procedure programmatically using C# but came back with
> empty handed :-(
> I know it is definitly possible (i.e. what the Query Analyzer can do).
> I will appreciate any help.
> thanks

Reply to this Message

Sooraj PM - 26 Sep 2004 13:29 GMT

Hi Abdullah

Do you mean to create a stored procedure for a table? If yes, you can refer
to the Code Smith site (http://www.ericjsmith.net/codesmith/default.aspx).
The tool is a templated based code generator which will also gives the Stored
Procedure outputs.

Regards
Sooraj
Microsoft Community Star

> Hi every one I have tried to search for any links, hints clues on how to
> create a Stored Procedure programmatically using C# but came back with empty
[quoted text clipped - 4 lines]
>
> Abdulla

Reply to this Message

Sijin Joseph - 26 Sep 2004 17:18 GMT

Check out
http://www.c-sharpcorner.com/Code/2004/May/CreatingDynamicDatabase.asp

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph

> Hi every one I have tried to search for any links, hints clues on how to
> create a Stored Procedure programmatically using C# but came back with empty
[quoted text clipped - 4 lines]
>
> Abdulla

Reply to this Message

How to create a Stored Procedure programmatically using C#

Free Magazines