CODEWITHSUNDEEP
c#sqlschemaclrdatabase-schema
To Ka
To Ka

Reputation: 650

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

Upvotes: 5

Views: 716

Answers (1)

Yahia
Yahia

Reputation: 70379

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

Upvotes: 2

Related Questions