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

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.