generate store procedure in C#.net that reflect is Database

Question

My point is how can i generate a store procedure in C# .net including some queries

in that store procedure in a particular database and finally as a result the store procedure should reflect in

that database with the mentioned above query.

Please guide me.

Jignesh Trivedi · Answer

hi I think in this can you can use Command object as well as SQL Management Objects (SMO). Please refer http://www.codeshode.com/2011/06/create-alter-drop-stored-procedures.html using command object cmd.CommandText = @exec('CREATE PROCEDURE MyTest AS BEGIN select * from testTable END'); cmd.ExecuteNonQuery(); hope this will help you.