SQL CLR project in vs2012

visual-studio-2012 sqlclr
laconicdev picture laconicdev · Aug 20, 2012 · Viewed 23k times · Source

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!

Answer

Damien_The_Unbeliever picture Damien_The_Unbeliever · Aug 20, 2012

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.

Related questions

Error 'LINK : fatal error LNK1123: failure during conversion to COFF: file invalid or corrupt' after installing Visual Studio 2012 Release Preview

I've installed Visual Studio 2012 Release Preview, and it appears to be fine, but now when I try to use Visual Studio 2010 to compile C++ projects, I get the following error message: LINK : fatal error LNK1123: failure during conversion to COFF: …

Read More
Is there a format code shortcut for Visual Studio?

In Eclipse there is a shortcut, Ctrl+Shift+F, that re-indents code and fixes comments and blank lines. Is there an equivalent for Visual Studio 2010?

Read More
how to reset <input type = "file">

I am developing a metro app with VS2012 and Javascript I want to reset the contents of my file input: <input type="file" id="uploadCaptureInputFile" class="win-content colors" accept="image/*" /> How should I do that?

Read More