SQL CLR project in vs2012

Question

After installing the version of VS2012, I can’t find the template for SQL CLR. How can I create a project of this type.

Thank!

Answer 1

All database objects are now created inside SQL Server database projects.

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

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

Then, if you go to Add -> New Item , you will find different categories on the left, including (vaguely) SQL CLR and SQL CLR C# . The first is for creating SQL scripts for adding CLR objects, the second for creating the CLR objects themselves.