How to create a Stored Procedure programmatically using C#

[Abdulla Herzallah]

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

 

[Cor Ligthert]

Abdullah,

Just create the SQL strings and execute those using the executenonquerry

I hope this helps?

Cor

 

[Guest]

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

 

[Sijin Joseph]

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


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