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

Alberto Poblacion - 25 Oct 2007 10:41 GMT

> 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?

If you decorate your source code with the adequate attributes, such as
[Microsoft.SqlServer.Server.SqlFunction(Name:="whatever")], then Visual
Studio is able to deploy it automatically to SqlServer when you run the test
project. No need to manually upload the dll during development time. You may
still want to write a sql script with all the CREATE statements, to be used
when you need to deploy or redeploy your dll on the production servers.

Reply to this Message

DR - 26 Oct 2007 19:33 GMT

thanks!

>> easiest way to upload a C# class library to a SQL server 2005 and deploy
>> as CLR function
[quoted text clipped - 11 lines]
> to be used when you need to deploy or redeploy your dll on the production
> servers.

Reply to this Message

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

Free Magazines