CODEWITHSUNDEEP
visual-studio-2012sqlclr
laconicdev
laconicdev

Reputation: 6440

SQL CLR project in vs2012

After installing the release version of VS2012, I am unable to find SQL CLR proect template. How can I go about creating a project of this type.

Thanks!

Upvotes: 44

Views: 23277

Answers (1)

Damien_The_Unbeliever
Damien_The_Unbeliever

Reputation: 239646

All of the various database objects are now created inside of SQL Server database projects.

They've removed the distinction between database projects (SQL Scripts) and SQL CLR projects.

So it's just File -> New -> Project, Installed -> Templates -> SQL Server, SQL Server Database Project.

Then, if you go to Add -> New Item, you'll find various categories on the left, including (confusingly) SQL CLR and SQL CLR C#. The first is for generating SQL Scripts for adding CLR objects, the second is for creating the actual CLR objects themselves.

Upvotes: 72

Related Questions