Free Tools to make SQLCLR development easier.

Articles

Current Articles | Categories | Search | Syndication

By Jonathan Kehayias @ Sunday, January 25, 2009 3:58 PM :: 974 Views :: 0 Comments

If you are using Visual Studio Professional, project templates for SQLCLR are included as a part of the installation. However, if you are using an Express Edition, this may not be the case. A few years back, Niels Berglund created a free downloadable template set for Visual studio that makes creating new CLR objects easier. It is still available and free for download from:

http://sqlblogcasts.com/blogs/nielsb/archive/2005/06/21/SQlClrProject-_2D00_-Visual-Studio-Project-Type-for-SQL-Server-2005.aspx

Another tool the Niels wrote may also be of interest to you if you are not using Visual Studio Professional for developing SQLCLR projects, called SQLCLRProject. This is an addin to Visual Studio that can be used to deploy your assembly and create the TSQL object wrappers from Visual Studio directly.

http://nielsb.wordpress.com/sqlclrproject/sqlclrdl/

This functionality has always existed in Visual Studio Professional, but not in other sku's. This addin makes deploying changes to SQL CLR assemblies a breeze in any version of Visual Studio.

Posted @ Sunday, January 25, 2009 3:58 PM by Jonathan Kehayias

Comments

Currently, there are no comments. Be the first to post one!
You must be logged in to post a comment. You can login here

Survey

Which of the following CLR objects are you currently using in SQL Server?
User-Defined Functions
User-Defined Types
Stored Procedures
Triggers

Submit Survey View Results

Links

Database Administrator’s Guide to SQL Server Database Engine .NET CLR Environment

CLR Integration Team Blog

MSDN SQL Server CLR Forum

Article Categories

Copyright 2007 by SQLCLR.net Terms Of Use Privacy Statement
Website graphics provided by Matt Green Designs
Page generated in 0.0780025 seconds.

All information and example code on this site is provided 'as-is', without any express or implied warranty. In no event will the authors be held liable for any damages arising from its use.

This site is in no way affiliated with Microsoft. Unless specifically stated otherwise, nothing should be construed to represent the official positions or opinions of Microsoft and/or its Employees.