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

microsoft.public.dotnet.framework

24 Oct 2007 10:00 PM

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?

25 Oct 2007 5:25 AM

Henning Krause [MVP - Exchange]

Hello,

if you are working with a Visual Studio Solution and have the Project
Template for SQL Server Projects installed, you can just hit "Deploy" in the
Build menu.

Kind regards,
Henning Krause

Show quote

"DR" <softwareengineer98***@yahoo.com> wrote in message
news:eG52XloFIHA.3980@TK2MSFTNGP03.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?
>