Visual Studio CLR to SQL with a service reference


  • Hello,

    I am having some problems figuring this out. I need to add CLR functions to MSSQL 2008 that use an external website reference. I think I will have to create a project that uses SQL clr and then add another project that uses a form or command line c# to access the namespace of the service reference. I am having some trouble putting this all together. Any help would be appreciated.  

    So basically have a sql server call a clr function from a c# project which in turn calls a form in another project to run the reference. If there are any easier ways of doing this please let me know.

    Wednesday, December 2, 2015 2:36 AM