Hi,
Is it possible to call the DNN API from a SQL server CLR stored procedure.
I've tried to install the dotnetnuke API in the database as follows:
CREATE ASSEMBLY DotNetNukeAPI
FROM 'I:\Inhouse\DotNet\Framework4_0\Components\DotNetNukeDevDB\DotNetNukeDev\bin\Debug\DotNetNuke.dll'
WITH PERMISSION_SET = SAFE;
Which gives the following error, stating that the system.web dll needs installing:
Assembly 'DotNetNuke' references assembly 'system.web, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(failed to retrieve text for this error. Reason: 15105)). Please load the referenced assembly into the current database and retry your request.
When I install the system.web dll it says the system.drawing.dll needs installing and so on.
Is there an easier way to make reference the DNN API? Or any better way to call .net from a stored procedure?
The reason I'm trying to make a call to the DNN API is that I'm using a 3rd party module which can call stored procedures, my only option is to make my call from there.
Would be very grateful for any suggestions, ideas, etc.
Steve.