Re: easiest way to upload a C# class library to a SQL server 2005 and deploy as CLR function
- From: "Alexander Vasilevsky" <alvas@xxxxxxxxx>
- Date: Thu, 8 Nov 2007 17:34:34 +0200
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@xxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:OQEkOloFIHA.3980@xxxxxxxxxxxxxxxxxxxxxxx
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?
.
- Follow-Ups:
- Prev by Date: Re: CLR Shared Memory, C# DLL load
- Next by Date: Re: How to create a CLR DLL for Sql Server 2005? Is it just any .net class library that you can load into Sql Server 2005 or is there some special project type that I need to start with?
- Previous by thread: Re: CLR Shared Memory, C# DLL load
- Next by thread: Re: easiest way to upload a C# class library to a SQL server 2005 and deploy as CLR function
- Index(es):
Relevant Pages
|
Loading
