Menu
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!
312
To add a CLR database object to your project. Right-click the TradeDev database project in Solution Explorer, select Add, then New Item. Select the C# SQL CLR template, then SQL CLR User-Defined Function. Accept the default name and click Add.
SQL CLR or SQLCLR (SQL Common Language Runtime) is technology for hosting of the Microsoft . NET common language runtime engine within SQL Server. The SQLCLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment.
CLR functions can be used to access external resources such as files, network resources, Web Services, other databases (including remote instances of SQL Server). This can be achieved by using various classes in the . NET Framework, such as System.IO , System.
To determine if CLR is enabled, execute the following commands: EXEC SP_CONFIGURE 'show advanced options', '1'; RECONFIGURE WITH OVERRIDE; EXEC SP_CONFIGURE 'clr enabled';
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.
153
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
