calling a C# assembly from SQL Server 2005

Hi,

I have got a simple C# assembly which call a ASP.net web service and executes a webmethod, now i want to call this assembly from sql server 2005 within the sql server function. can any body let me know how to do it.

Thanks

I suggest you get a copy of "Professional SQL Server 2005 CLR Programming" published by WROX - ISBN 0-470-05403-4. You should be able to read a copy on Safari.

The rules on what may and may not be called are lengthy. It would have to be used with a permission set of EXTERNAL_ACCESS as it access the network. Not all DBA's will allow this.

Have you rigoursly unit tested the application? Do you tests reach at least 80-90% code coverage?

Depending on how exactly you wrote your application, you might have to rewrite some of it. For example the SQL access methods are in a different namespace within the SQL CLR.