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

Question

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

Answer 1

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...