Published on InterSystems Developer Community (https://community.intersystems.com)

Home > How to call a class query from .NET client application

Question
Güvenal · Oct 22, 2019

How to call a class query from .NET client application

Hello!
There is a class query “MemberStatusList” in the SYS.Mirror class that I would like to call from a .NET client application. 
I know that means that there is also a generated class method called MemberStatusListFunc. 
What is the best way if any exist to call them from a .NET application?
Just see if anything responded I tried using something like
…
IRIS iris = IRIS.CreateIRIS(conn);
var returnValue = iris.ClassMethodString("%SYSTEM.Mirror", "MemberStatusList", "NAMEOFTHEMIRROR")
---
That executes the method and returns the reference as a string to a %SQL.ClassQueryResultSet.
Obviously I would like to have a recordset of some sort to itterate so that call will not work for me.
I looked at using IRISCommand but I cannot figure out how to call the class query.
Is this doable or should I look for another solution?

(the cache database is in a Healthshare HealthConnect 2019.1 installation)


Best regards,
Magnus

#.NET #Caché

Source URL:https://community.intersystems.com/post/how-call-class-query-net-client-application