How to create CLR procedure in C# that will be deployed in schema other than DBO

I would like to create an SQL function that will be deployed in a schema开发者_如何学运维 other than DBO.

I found a post where a workaround with post build script is explained.

How to force dbo schema name?

I could use the above mentioned solution, but i kinda feel there should be something more civilized that that. Some parameter settings maybe, or attribute.

Thank you

There are two options to achieve what you want:

• you can configure the owner of the Procedure in the project settings/tab database
• otherwise the default schema of the connection you use in VS is the one getting used

So if you want it put in a different schema you either use a connection with your target schema as default schema or configure the project settings accordingly...