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!
Add a comment
|
1 Answer
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.
answered Aug 20, 2012 at 14:05
Damien_The_Unbeliever
241k28 gold badges358 silver badges470 bronze badges
5 Comments
Joakim
"So it's just File -> New -> Project, Installed -> Templates -> SQL Server, SQL Server Database Project." Only problem is that I don`t have SQL server under templates. How do I resolve this?
Alex B
@Joakim: you must install Microsoft SQL Server Data Tools if you don't have the templates (msdn.microsoft.com/en-us/data/tools.aspx)
Ryan R.
For me: File -> New Project -> Installed -> Templates -> Other Languages -> SQL Server
JSacksteder
I seem to have the 'sql clr' and 'sql clr vb' templates available in ssdt 2010 and ssdt 2012. I'm open to suggestions on how to get 'sql clr c#' added. Causes or solutions?
craig
Upped for being applicable to VS 2013.