Create a database stored procedure from .NET?

Question

I would like to create a stored procedure in my database from within C# code.

How can I do this?

FOR INSTANCE: Using Microsoft SQL Server, I just want to create a stored procedure sp_GetUsers in the database that takes an int parameter userid and a simple statement such as

SELECT * FROM Users WHERE ID = @userid

This would be great because I could check the DB for the existence of that stored procedure, and if it doesn't, I just create from within code.

Create a procedure? Or invoke one? Can you give an example of the scenario? — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Nov 20, 2012 at 18:52

SLaks · Accepted Answer · 2012-11-20 18:48:31Z

6

You can run arbitrary DDL statements:

new SqlCommand(@"CREATE PROCEDURE ...").ExecuteNonQuery();

answered Nov 20, 2012 at 18:48

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hall.stephenk · Accepted Answer · 2012-11-20 18:49:43Z

0

This is possible. All you have to do is execute a CREATE PROCEDURE statement via your open DB connection. If you can give us an example of your DB connection/query code right now, along with the DB vendor you're using (i.e. MS SQL, DB2), then we could probably give you a hard and fast example.

answered Nov 20, 2012 at 18:49

hall.stephenk

1,1657 silver badges10 bronze badges

Collectives™ on Stack Overflow

Create a database stored procedure from .NET?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related