How to Call a Cache Routine from the .NET Cache Client using C#

Question

Question

Matthew Long · Jan 23, 2019

#.NET #Caché

Hi All,

Is it possible to call a Cache Routine using the .NET Cache Client instead of just SQL statements?

If so, can someone provide an example?

using InterSystems.Data.CacheClient;
using InterSystems.Data.CacheTypes;

Thanks,

-Matt

Discussion (3)1

Log in or sign up to continue

Robert Cemper · Jan 24, 2019

You could use the feature that any Classmethod may also serve as Stored Procedure.

Like this:

Class User.Remote { ClassMethod Echo(inout As %String) As %String [ SqlName = Demo, SqlProc ] { return "Echo:"_inout } }

And then you may call your Procedure like this: getting back

SELECT DEMO('hello WORLD')

getting back

Echo:hello WORLD

All you have to care for is to return something.
what happens inside your ClassMethod is up to you and doesn't need to be related.

0 0

score 0 · Answer 1 · 2019-02-04T14:02:10-05:00

Matthew Long · Feb 4, 2019

Can you call a XT Mumps/Cache routine, from the client software?

0 0

score 1 · Answer 2 · 2019-02-04T14:18:25-05:00

YES! you can!

Just extend the method (just some example)

ClassMethod exmple(inout As %String) As %String [ SqlName = Example, SqlProc ]
{
do prepare^myMumps(inout)
set return=$$return^myMUMPS()
;;; or whatever is required
return "Echo:"_return
}