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.