easiest way to upload a C# class library to a SQL server 2005 and deploy as CLR function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DR - 24 Oct 2007 23:00 GMT

easiest way to upload a C# class library to a SQL server 2005 and deploy as
CLR function

Do I have to upload the .dll and then run sql command to load it into sql
server, or is there a more integrated way to do this in visual studio 2005
with a SQL Server Project? or do i have to manualu upload the DLL in all
cases? Any tutorial on CLR with Visual Studio 2005 IDE to Sql Server 2005?

Reply to this Message

Alexander Vasilevsky - 08 Nov 2007 15:34 GMT

Please try CREATE ASSEMBLY (Transact-SQL)
Please see code below from BOL

DECLARE @SamplesPath nvarchar(1024)
SELECT @SamplesPath = REPLACE(physical_name,
'Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf',
'Microsoft SQL Server\90\Samples\Engine\Programmability\CLR\')
FROM master.sys.database_files
WHERE name = 'master';
CREATE ASSEMBLY HelloWorld
FROM @SamplesPath + 'HelloWorld\CS\HelloWorld\bin\debug\HelloWorld.dll'
WITH PERMISSION_SET = SAFE;

http://www.alvas.net - Audio tools for C# and VB.Net developers

> easiest way to upload a C# class library to a SQL server 2005 and deploy
> as CLR function
[quoted text clipped - 3 lines]
> with a SQL Server Project? or do i have to manualu upload the DLL in all
> cases? Any tutorial on CLR with Visual Studio 2005 IDE to Sql Server 2005?

Reply to this Message

DR - 14 Nov 2007 01:43 GMT

thanks but it turns out that no one should EVER manualy issue a CREATE
ASSEMBLY command. this is done via visual studio project settings. manualy
deploying CLR creates unessicary maintinence issues.

> Please try CREATE ASSEMBLY (Transact-SQL)
> Please see code below from BOL
[quoted text clipped - 19 lines]
>> all cases? Any tutorial on CLR with Visual Studio 2005 IDE to Sql Server
>> 2005?

Reply to this Message

Rate this thread:

easiest way to upload a C# class library to a SQL server 2005 and deploy as CLR function

Free Magazines