SQL CLR questions for SQL 2014

%3CLINGO-SUB%20id%3D%22lingo-sub-1814876%22%20slang%3D%22en-US%22%3ESQL%20CLR%20questions%20for%20SQL%202014%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1814876%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20an%20active%20project%20in%20SQL%202014%20Standard%20where%20SQL%20CLR%20was%20used%20and%20there%20is%20a%20need%20to%20add%20an%20assembly%20that%20has%20a%20COM%20dll%20reference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20please%20get%20some%20feedback%20on%20this%20regarding%20experiences%20and%20what%20concerns%20there%20are%20for%20performance%20and%20other%20issues%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20thought%20is%20to%20use%20WCF%20to%20loosely%20couple%20but%20again%20I%20would%20ask%20for%20feedback%20regarding%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20any%20thoughts%20and%20ideas%20surrounding%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBob%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1814876%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQL%202014%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20CLR%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello all,

 

We have an active project in SQL 2014 Standard where SQL CLR was used and there is a need to add an assembly that has a COM dll reference.

 

Can I please get some feedback on this regarding experiences and what concerns there are for performance and other issues?

 

Another thought is to use WCF to loosely couple but again I would ask for feedback regarding this.

 

Thanks in advance for any thoughts and ideas surrounding this.

 

Bob

0 Replies