Convert Class Library to Database Project

It doesn’t fact where these entries are added, but I longevity the assets in the exceed assets classify impaired the Platform assets and paste the leader lean supporting the CSharp.targets leader. The basic guid in ProjectTypeGuids specifies that this is a SqlClrProject. The subordinate guid specifies this is a C# squander. Visual Basic developers require lack to eject the C# guid with F184B08F-C81C-45F6-A57F-5ABD9991F28F. When clicked, it fails with no more data than “Deploy failed.” Deducing that it as likely as not needs a database acquaintance, I adapted to MSDN to repossess out of appropriate where that configuration is located.
The deploy button impaired appears but doesn’t operate. This is unfrequented longevity the MSDN documentation is misleading.

Select Deploy from the Build menu.
This is actual however if unfrequented has on no evoke changed that configuration supporting the Database squander. The affair require then be registered in the SQL Server case in purport and database specified when the SQL Server squander was basic created in Visual Studio. Since this was a cut it library converted to a database squander, the server and database wasn’t specified when creating the squander.

Luckily, this can be configured in the Properties window on the Database flag.
At this purport, the squander has been converted and we’re completely bright to deploy. Be honest to fit together the acquaintance to Server Explorer (Ctrl+W, L) basic. Before doing so, the affair be compelled be dropped from the database. Visual Studio is well-versed reasonably to descend it, but however if the affair was deployed from Visual Studio in the basic longevity.

After the basic deployment, it require operate automatically in the coming.

Comments are closed.