Hi,
I have a written a C# assembly that I call from an SQL Server 2005 stored procedure. I have sucessfully added the assembly to SQL2005 and the code is working fine, however I am using a configuration file and it does not seem to pick up the changes I have made to the config file. I compiled the DLL to the following location:
C:\Work\Visual Studio 2005\ConsoleSyncCRMExchange\ConsoleSyncCRMExchange\bin\Debug\ElementusConsoleSyncCRMExchange.dll
And in this folder is a file ElementusConsoleSyncCRMExchange.dll.config which is my configuration file.
This is also the location I used when using CREATE ASSEMBLY command in SQL to add the assembly to SQL2005.
Once an assembly is loaded into SQL does it look for a different location for the config file, other than the location it was imported from ?
Any assistance would be useful
I have a written a C# assembly that I call from an SQL Server 2005 stored procedure. I have sucessfully added the assembly to SQL2005 and the code is working fine, however I am using a configuration file and it does not seem to pick up the changes I have made to the config file. I compiled the DLL to the following location:
C:\Work\Visual Studio 2005\ConsoleSyncCRMExchange\ConsoleSyncCRMExchange\bin\Debug\ElementusConsoleSyncCRMExchange.dll
And in this folder is a file ElementusConsoleSyncCRMExchange.dll.config which is my configuration file.
This is also the location I used when using CREATE ASSEMBLY command in SQL to add the assembly to SQL2005.
Once an assembly is loaded into SQL does it look for a different location for the config file, other than the location it was imported from ?
Any assistance would be useful
