How to create a CLR procedure in C # that will be deployed in a 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 explaining a workaround with a post-build script.

How to force dbo schema name?

I could use the above solution, but I seem to think that it should be something more civilized. Perhaps some parameter settings or attribute.

thank

Answer 1

There are two options for achieving the desired result:

• you can configure the owner of the procedure in the project settings / database tab
• , VS, - ,

, , , , ...