J i've got a question for you regarding deployment;
i created a new VS project named "MyCLRProjects, and added only your Partial Public class as an example;
it compiled, and i was able to run the command to add the assembly:
CREATE ASSEMBLY MyCLRProjects from 'C:\data\MyCLRProjects.dll' WITH PERMISSION_SET = SAFE
when i try to add the udf with the command below, i get this simple error:
Msg 6505, Level 16, State 2, Procedure fn_ReadHttpPage, Line 1
Could not find Type 'UserDefinedFunctions' in assembly 'MyCLRProjects'.
the code:
CREATE FUNCTION fn_ReadHttpPage(@pageToRead varchar(250))
RETURNS varchar(max)
EXTERNAL NAME MyCLRProjects.UserDefinedFunctions.ufnFunction
can you point out my obvious error? i'm sure my Root namespace is simply "MyCLRProjects"
Lowell