部署期间 CLR 存储过程的架构 [英] Schema for CLR Stored Procedure During Deployment

问题描述

我对配置 Visual Studio (2010) 感兴趣，以便在部署 C# CLR 数据库项目时，它会将内容放入 DBO 以外的架构中.我知道我可以更新函数/过程/等...它手动创建的包装器来实现这一点:CLR 存储过程:如何设置架构/所有者?

I'm interested in configuring Visual Studio (2010) so that when deploying C# CLR Database projects, it puts stuff in schemas other than DBO. I understand I can update the function/procedure/etc... wrappers it creates manually to make this happen: CLR Stored Procedures: how to set the schema/owner?

但是，我真的很想以某种方式使流程自动化.如果有人知道，我真的很感激答案！

However, I'd really like to automate the process somehow. If anybody knows, I'd really appreciate the answer!

推荐答案

应该提到的是，这个问题从 Visual Studio 2012 开始就已经过时了，它有一个用于生成的 T-SQL 包装器对象的默认架构"配置字段.这也已在以下答案顶部的更新"部分中注明;-) :

It should be mentioned that this question is obsolete as of Visual Studio 2012 which has a "Default Schema" configuration field for the generated T-SQL wrapper objects. This has also been noted in the "Update" section at the top of the following answer ;-) :

CLR 存储过程:如何设置架构/所有者?

这篇关于部署期间 CLR 存储过程的架构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！