Sir, I created a dll (SqlWcfServiceLibrary1.dll) using .net frammework 2008. My code has a reference of another assemble (WcfServiceLibrary1.dll) also. I want to create assemble in sql and use that assemble in a procedure. I am getting error that "Error while referencing external assembly". I am pasting all code that I used.... .cs page code - namespace SqlWcfServiceLibrary1 { public class SqlService1 { void SendToSql(string message) { SqlMetaData[] table = new SqlMetaData[1]; table[0] = new SqlMetaData("Message", SqlDbType.VarChar, 1000); SqlDataRecord row = new SqlDataRecord(table); row.SetValue(0, message); SqlPipe pipe = SqlContext.Pipe; pipe.SendResultsStart(row); pipe.SendResultsRow(row); pipe.SendResultsEnd(); } public static void GetMessage(SqlString name) { Assembly assembly = LoadAssembly("D:\OutCast\WcfServiceLibrary1\WcfServiceLibrary1\bin\Debug\WcfServiceLibrary1.dll", true); Type type = LoadType(assembly, "WcfServiceLibrary1.Service1", true); String message = ""; using (ServiceHost host = new ServiceHost(type)) { host.Open(); IService1 service1 = InitChannel(); message = service1.GetMessage(name.ToString()); host.Close(); } } static IService1 InitChannel() { Uri address = new Uri("net.tcp://localhost:8731/Design_Time_Addresses/WcfServiceLibrary1/Service1/"); ChannelFactory<IService1> factory = new ChannelFactory<IService1>(new NetTcpBinding(), new EndpointAddress(address)); return factory.CreateChannel(); } static Assembly LoadAssembly(String assemblyName, bool throwOnError) { Assembly assembly = null; try { assembly = Assembly.LoadFrom(assemblyName); } catch { } if (assembly == null && throwOnError) throw new Exception("Hello Sujeet, Error while referencing external assembly.rn rnAssembly '" + assemblyName + "' doesn't exist."); return assembly; } static Type LoadType(Assembly assembly, String typeName, bool throwOnError) { Type type = null; try { type = assembly.GetType(typeName, false, true); } catch { } if (type == null && throwOnError) throw new Exception("Error while loading type.rn rnType '" + typeName + "' doesn't exist."); return type; } } [ServiceContract] public interface IService1 { [OperationContract] string GetMessage(string name); } } using above code I created a dll and using it in sql. SQL Code - -- create assembly CREATE ASSEMBLY SqlWcfServiceLibrary1 FROM 'D:OutCastSqlWcfServiceLibrary1SqlWcfServiceLibrary1binDebugSqlWcfServiceLibrary1.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS GO --create procedure -- external name is composed by
Software/Hardware used: