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

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?

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


"DR" <softwareengineer98037 (AT) yahoo (DOT) com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:OQEkOloFIHA.3980 (AT) TK2MSFTNGP03 (DOT) phx.gbl...

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?

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.

"Alexander Vasilevsky" <alvas (AT) alvas (DOT) net> wrote

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


"DR" <softwareengineer98037 (AT) yahoo (DOT) com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:OQEkOloFIHA.3980 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
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?