10 January 2006 02:15 nielsb

Updated Version of SqlClrProject


Back in December (26:th to be exact) I released a new version of the SqlClrProject and wrote about it here [0].

One drawback of the deployment functionality was that you could only deploy locally as the deployment process used the CREATE ASSEMBLY based on the location of the assembly; i.e. CREATE ASSEMBLY myasm FROM 'path_to_dll'.

Well, this is now fixed, as I have chenged the code so it now uses the binary representation of the assembly. You who know your CREATE ASSEMBLY stuff may think "what about dependent assemblies?" as dependent assemblies are not automatically deployed when using the binary representation. Well, the code handles that as well, it uses reflection to see what the dependent assemblies are and retrieves the binary representation of those as well during deployment.

So if you have installed the original SqlClrProject which was available from here [1], there is now an update here [2]. Download the update, un-zip and follow the readme.txt. The original download has now been updated as well, so if you haven't retrived it yet, go and get it [3].

[0]: http://staff.develop.com/nielsb/PermaLink,guid,200487e5-f2e2-449c-8a3f-ee28e6aa8735.aspx

[1]: http://staff.develop.com/nielsb/code/DeployPropAndAddIn.zip

[2]: http://staff.develop.com/nielsb/code/yukondeployupdate.zip

[3]: http://staff.develop.com/nielsb/code/DeployPropAndAddIn.zip


Comments

# re: Updated Version of SqlClrProject

08 November 2007 10:05 by Paul Smith

I've been using the previous version of SqlClrProject, but I notice that the latest version uses Add-In Manager which is not available in VB 2005 Express. Can I skip this install and continue to use the External Tool entries that I have set up?

# re: Updated Version of SqlClrProject

14 January 2008 15:45 by nielsb

Hi Paul,

Sorry for being so very late with my reply. Seeing that I have just released a new version you are probably better off to download the new version and install everything but the add-in and the templates (they have separate installation scripts/msi's in the zip file).

Niels