C#以编程方式更改存储过程

好吧,所以我发现了为什么它没有更新。不管出于什么原因,它似乎需要 刷新; First 在我重写正文之前。

SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConnection"].ConnectionString);
ServerConnection srvCon = new ServerConnection(sqlCon);

sqlCon.Open();

Server srv = new Server(srvCon);
Database db = srv.Databases[sqlCon.Database];
StoredProcedure sp = new StoredProcedure(db, "spRDLDataFetcher");

sp.TextMode = false;
sp.AnsiNullsStatus = false;
sp.QuotedIdentifierStatus = true;
sp.ImplementationType = ImplementationType.TransactSql;
sp.Schema = "dbo";

sp.Refresh(); //What was needed to make work
string orgSPText = sp.TextBody;

sp.TextBody = "SELECT blah FROM MyTable WHERE ID=1";
sp.Recompile = true;
sp.Alter();

这个 sp.重新编译=真; 真的不需要。没有它也行,但我喜欢把它放在那里,只是为了好玩。