Using PISDK in a SQLServer CLR Assembly

Discussion created by mnadeau on May 7, 2014
Latest reply on May 16, 2014 by Marcos Vainer Loeff

I created a class library in .Net to allow me to interface with PI in realtime in SQL Server.


I have resgistered it as an assembly in SQL Server and created my Stored Procedure (which uses the assembly) to execute.


My routine to insert values into PI for a tag is working properly.  My routine to get the value of a PI tag is not working.  I put in some debug messages into my class library to pinpoint where the problem is.  It is on this line of code. :


dblTagResult = pv.Value (pv is of type PISDK.PIValue)


I get the error message -> Dynamic operations can only be performed in homogenous AppDomain.


I wrote a wrapper windows form to also execute my class library and it is working fine.  Its only when I introduce SQL Server I have the issue.




Thanks in advance for your assistance.